Forum Discussion

Abhijit's avatar
Abhijit
New Contributor
9 years ago

How to read the first line of source CSV and produce last line of output file

The first line of the source CSV has to be converted into the second line of target (also to add a first line manually). Rest of the lines in the target file to produce line-by-line for each source f...
itrpkov's avatar
itrpkov
Employee
9 years ago

One mechanism that can be used to isolate separate lines is to use Copy snap after CSV file has been parsed, for example, with 3 (or more) output views. You can then use Filter snaps and snap.in.totalCount function as a filter expression. To get the first line you can specify snap.in.totalCount ==1, for the second line you can specify snap.in.totalCount ==2 etc. Then you can use Union snap to collect the lines back etc. Hope this helps.

  • Abhijit's avatar
    Abhijit
    New Contributor
    9 years ago

    Thanks for your reply. I found a working solution allready. I am writing 4 different structure/ lines into 4 different files locally into SnapLogic and then reading/merging them together to produce the desired target file. Thanks for your suggestion though.