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 file, after line -2 onward. Hope it make sense, as following:

                                   Target Line 1 (FIXED VALUE - beginning of file marker)

Source Line-3 ---->>>> Target Line 2 (different processing logic - convert data from source line 3)
Source Line-2 (Header of source data) ---->>>> Ignore
Source Line-3 ---->>>> Target Line 3
Source Line-4 ---->>>> Target Line 4
Source Line-5 ---->>>> Target Line 5
…
…
------------------- ------ >>>> Target Last Line ( different processing logic - convert data from source line 1 - End of file marker).

TAB separated target file, have one format for line-1, another for line-2, another for last line and anoter format for rest of the middle between Line-3 to last-line.

2 Replies

  • 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.