Generating individual files based on 'n' records from the input data (excel) file
Hi Community,
Looking forward to your suggestions (I’m brand new to snapLogic and wanting to learn more!)
→ Input is an excel file with multiple columns, I’m planning to fetch 2 columns only from those multiple columns (this has been achieved so far)
→ For instance, the total records in an excel file are 10, I would want 10 individual csv and html files (with those 2 columns only) generated with filename as (row1col1 value).csv, (row1col1 value).html, (row2col1 value).csv, (row2col1 value).html and so on and so forth.
Thank you in advance for your help 🙂
The solution was achieved by using "Group By N" snap with the below settings:
Some transformation happened after that and it was fed to a pipeline execute which generated individual html/csv files for me. This has worked seamlessly for 45k+ files in a single execution though it takes around 15m for pipeline completion.
Don't forget to use the below snap "Document to Binary" before generating html files via the File writer:
Thank you.
Best Regards,
Darsh
