Forum Discussion

SL12345's avatar
SL12345
New Contributor III
3 years ago
Solved

Adding column at the beginnging of mapped array

Hi snaplogic experts,

i have csv file with 56 columns. In order not to map field after field and have 56 rows in mapper, iam using this function (mapping and replacing . with , ).

$.mapValues(x => x.replaceAll('.', ','))

but my problem is: i need to add yesterdays date as first column.

is there any chance to add column to this function or do i need to map all columns and new column will be added as first column?

thank you

  • koryknick's avatar
    koryknick
    3 years ago

    I’m not sure what the mapValues is doing in your example, but you can use extend() to add to the JSON document. In this case, you would create a new object with your “yesterday” field and extend that with the incoming object. Something like this:

    { "yesterday" : Date.now().minusDays(1).toLocaleDateString() }.extend($)

1 Reply

  • koryknick's avatar
    koryknick
    Employee
    3 years ago

    I’m not sure what the mapValues is doing in your example, but you can use extend() to add to the JSON document. In this case, you would create a new object with your “yesterday” field and extend that with the incoming object. Something like this:

    { "yesterday" : Date.now().minusDays(1).toLocaleDateString() }.extend($)