โ03-10-2022 06:36 AM
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 ๐
โ03-10-2022 06:57 AM
Hi @darshthakkar,
Try using Pipeline Execute Snap, so you can write one file per one input document. Also you can pass snap.in.TotalCount as Parameter so you can name the files as you listed before.
Below is the Pipeline Execute Snap Settings:
The Child Pipeline that is used for writing the files should look like this:
And the File Writer Snap Settings:
Note * This is only for csv files, there is not a html formatter in the available Snaps. *
For dynamic formatting a html file head over to https://community.snaplogic.com/t/how-to-generate-a-html-file-with-snaplogic/1186
BR,
Aleksandar
โ03-10-2022 06:59 AM
Thank you @AleksandarAngelevski, I will try with the solution youโve provided.
Your help is much appreciated.