Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Converting value of input schema to distinct columns

Hi Team, I’m reading a text file and wanted to fetch DISTINCT columns out of the data itself, screenshot below for your reference. .txt file: When I read the above data in snaplogic, the f...
cjhoward18's avatar
cjhoward18
Employee
4 years ago
Copy Link

Hi,

Using this expression in a Mapper snap:

$['Customer Security Segment'].split(";").reduce((accum, curVal, index) => accum.extend({[$['Customer Super Key'] + (index + 1)]: curVal }), {})

You can create the object you are looking for from the input given.

fkhan060's avatar
fkhan060
New Contributor II
4 years ago
Copy Link

Thank you CJ!, that did the trick but it I also had to add an $.extend at the root level to achieve what I was going for, so my finally expression ended up looking like this in the mapper Snap:

$.extend($[‘Customer Security Segment’].split(“;”).reduce((accum, curVal, index) => accum.extend({["Customer Security Segment " + (index + 1)]: curVal }), {}))