Abhijit
New Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: How to read the first line of source CSV and produce last line of output file
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.2KViews0likes0CommentsHow 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.3.6KViews0likes2CommentsUNION: Preserve source data sequence
I need to preserve the sequence of source data to produce line by line output. It seems UNION snap cannot do that as I just find “December 20, 2014: Preserve order was removed.” comment in SnapLogic docs. So then, what option I have??? Fox example, if in the source data file, there are 3 records, with X, Y, Z in each line sequentially, then in the target file, after conversion, it should generate same sequence, say X1, Y1, Z1 in each line.3.7KViews0likes4Comments"JSON Splitter" snap truncate data!
Is there any limitation of data size that “JSON Splitter” snap can handle? I get a 36mb json as input and output less than 1mb. I noticed “JSON Splitter” simply truncates the data!!! Ideally it should not but it is happening!!! Anyone find such odd behavior ? Unfortunately I have to split the JSON to process each sub-element. For smaller size of source file, it works fine though.4.7KViews0likes4CommentsPickup string from source file-name to use in pipe-line
I need to read the plant-code which is either part of the source file-name or folder-name that is read via SFTP and then generate an output file with the same plant-code as part of the target file-name. How can I do that? The second part of the same question is, I need to use the same plant-code in a mapper snap, to apply mapping logic based on plant-code. How can I pick-up the plant-code into a variable or constant, to use in the mapper?4.6KViews0likes3Comments