05-03-2017 06:38 AM
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.
05-10-2017 06:25 AM
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.
05-10-2017 06:40 AM
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.