SnapLogic - Integration Nation

philliperamos · ‎11-12-2019

Good day community.
I have a CSV file, see attached, which I would like to pick up the last three fields from the right as their own fields, and the rest of the record/line as a “value” field.
sampleData.txt (80 Bytes)

So basically, the output should be
[value] [row] [pipeID] [date]
where is the remainder of the data in the row.

Is this possible?
Thanks

nsingam · ‎11-13-2019

Hi Philliperamos,

I created a pipeline that will keep the last 3 columns as it is and the rest of the row values will be concatenated under the value field.

Here I am attaching pipeline and sample data file.
Hope this is what you are required.

Dynamic_csv_column_change_2019_11_14.slp (10.3 KB)
sample.txt (231 Bytes)

View solution in original post

philliperamos · ‎11-13-2019

@nsingam it works great! Thanks!

So my file doesn’t have header info, so now I’m just trying to set a header name to fieldX , fieldY and fieldZ

Thanks again!

SnapLogic - Integration Nation

Read a CSV file from the Right to Left