@nsingam Thanks for this.
I forgot to mention that the number of columns can change.
So one file could have 10 columns, another file could have 7, but the last 3 columns would always be ROW, PIPEID and DATE.
Hence why I wanted to be able to read from right to left.
@philliperamos, I am not hardcoded anything in that pipeline. It will work for any no of columns in your CSV file. If for any reason the last 3 columns are different than ROW, PIPEID, DATE then those new columns will be keep as it is and these columns will come under value.
