Forum Discussion
If you can guarantee that these same 8 fields are always present, you could do a Group By N of 8, then process the array into an object. If missing values would remove the line, it becomes a bit more complex and may require a Script snap to handle the contextual parsing of the input.
@koryknick - We can handle “n” no. of rows with Group Size as 0
I will modify my 50 to 0 now as 0 will handle all the incoming rows.
- Aleksandar_A2 years agoContributor III
Hello SL12345,
Please refer to the attached sample pipeline, and let me know if this helps you!
Regards,
Aleksandar.
- SL123452 years agoNew Contributor III
Looks good but question .... in my example - one row has more fields than another row
Is it possible to "connect"/export two lines into one file but without empty field at the and of shorter row?
(Mercedes is shorter and CSV formatter creates last empty field) instead of this:
"Mercedes";"6658";"TypeS";"2022";""
"Audi";"5558";"TypeA8";"2022";"Diesel"get This
"Mercedes";"6658";"TypeS";"2022";
"Audi";"5558";"TypeA8";"2022";"Diesel"Thank you
- Aleksandar_A2 years agoContributor III
Try with this one.