Forum Discussion

makeshwar's avatar
makeshwar
New Contributor II
5 years ago
Solved

Redshift bulk load

Hi team, Looking for a suggestion/enhancement to achieve the below senario. when i read a csv file (it might have \n\r (windows) & \n(unix) ). Who to fix this … Today I read the file and when I d...
pattern
pipeline
transform
  • koryknick's avatar
    koryknick
    4 years ago

    Remapping all field names can be done using the Object.mapKeys() method. For example:

    Hope this helps!

  • darshthakkar's avatar
    darshthakkar
    2 years ago

    Hi mkadange,

    Welcome to SnapLogic and community. Yes, you can simply drag and drop the columns on the target path as you did for input/expression. Please try that out once for a small set and selecting All and dropping it on the target will do the needful.

    Also, let's assume, out of 400, you need to select 40 which are not in the order, drag and drop will automatically map it for you.

    Please keep us posted with your results.

    Regards,

    Darsh

bojanvelevski's avatar
bojanvelevski
Valued Contributor
5 years ago
Copy LinkReport

If I understand correctly, this is the right output format?

If that so, you can try the following expression:

$Records.map(record => {“Award”: record.Award, “Sequence”: record.Award.map((x, index) => (record.Award.slice(0, index + 1).filter(y => y == x).length.toString()).length == 1 ? (“0” + record.Award.slice(0, index + 1).filter(y => y == x).length.toString()) : (record.Award.slice(0, index + 1).filter(y => y == x).length.toString()))})

It’s a bit complex, but only because of it’s functionality to check the sequence number. If it’s one digit number, it will add “0” in front of it, if not, it will show the actual number.

I surely hope that this will help,
BR,
Bojan

  • petar_rajchinos's avatar
    petar_rajchinos
    New Contributor III
    6 years ago
    Copy LinkReport

    Hi Ajay,

    I would suggest you to send the token in the header of the POST call. Similar like the picture below. Have you tried that before?

    Let us know if that helped.

    Regards,
    Petar