Forum Discussion

Madhu1's avatar
Madhu1
New Contributor
3 years ago

Insert Header and Footer Rows to the CSV/TXT file

Greetings to the community ! @koryknick I have a requirement to build the txt file which has the format of Header,Body,Footer rows as shown in below screenshot. I can able to build the bod...
koryknick's avatar
koryknick
Employee
2 years ago
Copy LinkReport

Abhishek_117 - I think the answer you're looking for is already an option in the CSV Parser snap.  In the "Header size error policy", select "Trim record to fit header".  This will ignore any extra columns in the input data.

Hope this helps!

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    3 years ago
    Copy LinkReport

    Hi @manohar,

    You can try by using Mapper Snap with the following expression for the attachments:

    sl.range(0,$docname.length).map((x,ind) => {"docname":$docname[ind],"id":$id,"docext":$docext[ind],"docid":$docid[ind]})

    Try with this, and let me know if this helps you.

    BR,
    Aleksandar.