The title says it all, I want to add columns (around 600) and their start and end position automatically using a SnapLogic trick or Script. It’d be great if I could check the box for ‘Trim Column Data’ as well.
Below is the pic for snap details:
Manual work seems a lot and can invite errors. We already have a well-formatted CSV with column names and their start and end position and I would be able to automate the process of adding columns to FixedWidthParser. Any help and ideas are appreciated!
If it’s not possible then I’d appreciate ideas about how can I develop a solution myself.