Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago
Solved

Read a CSV file from the Right to Left

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. sa...
  • philliperamos's avatar
    philliperamos
    Contributor
    6 years ago

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

    • nsingam's avatar
      nsingam
      Employee
      6 years ago

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

      • philliperamos's avatar
        philliperamos
        Contributor
        6 years ago

        Ok great! Thanks!
        I’ll test it with various files with different column amounts and let you know!

  • philliperamos's avatar
    philliperamos
    Contributor
    6 years ago

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