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
Hi @vaidyarm,
You can try to achieve that the way I did in the below pipeline. Please note that this might not be the most optimal way achieving what’s needed.
–sl-comm-pivot-rows-to-columns_2023_04_11.slp (14.5 KB)
BR,
Aleksandar.
That worked perfectly
Thanks a Lot @AleksandarAngelevski 😀
Not able to download the slp file, is this broken as part of new community page migration?
We’re finding issues with some of the links and have an open issue with our vendor.
