This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Read a CSV file from the Right to Left

Go to solution
philliperamos
Contributor

‎11-12-2019 06:33 AM

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

Preview file
1 KB
0 Kudos
1 ACCEPTED SOLUTION

Go to solution
nsingam
Employee
Employee

‎11-13-2019 11:17 AM

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

Dynamic_csv_column_change_2019_11_14.slp
Preview file
1 KB
0 Kudos
5 REPLIES 5

Go to solution
philliperamos
Contributor
In response to nsingam

‎11-13-2019 12:48 PM

@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!

0 Kudos