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

    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)

  • tstack's avatar
    tstack
    Former Employee
    7 years ago
    Copy LinkReport

    You can use a Mapper with Passthrough enabled, set the Expression column to the path to be deleted, and leave the Target Path empty:

    The “Leave blank to delete source path” text in the target field is supposed to guide the reader in this direction. I guess it’s not working too well…

  • RLE's avatar
    RLE
    New Contributor
    7 years ago
    Copy LinkReport

    Just don’t put the field at all in the list. E.g. where $unwantedField is, make that blank and leave Target Path blank.