Formatting excel data
I have an Excel sheet with with below format:
In this Excel, column 1,2 and 3 remains common, and the data which i am suppose to send is in below output csv format:
Output:
QWE;1234;567890...
Forum Discussion
@aditya.gupta41
Yes you can remove the empty streams. First you need to uncheck the Insert null columns setting in the excel parser. This will automatically exclude the empty fields.
Next, I updated the expression in the mapper.
$.keys()[0].split("|").map(val => val.contains("_") ? val.substring(0, val.indexOf("_")) : val).map(keyStart => $.filter((val, key) => key.contains(keyStart)))
