Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago

Get column headers from within the file

Good day all, I have a .txt file that looks like: All the rows have the “header” info before the value. e.g. Column Ordinal: 13 Expected Data Type: Date Every row has the same info. (e.g...
jovan_j's avatar
jovan_j
New Contributor III
6 years ago

Hi philliperamos,

You can use mapKeys and mapValues function to extract the values from the file (the first mapper extracts the Keys, the second mapped extracts the Values), also make sure to unchecked the Columns header option in the CSV parser. Please see attached screenshot and pipeline. Hope this helps.

Regards, Jovan.JJ new pipeline 123_2019_11_06.slp (7.2 KB)

  • kachanta's avatar
    kachanta
    New Contributor
    3 years ago

    Yes you can do it. First setup the child object in the Related Object and Related External ID.

    setup the objects like this

  • prakarshjain510's avatar
    prakarshjain510
    New Contributor II
    3 years ago

    Hi Kishore,

    Thank you for the revert.

    I tried the way you have mentioned, but it is not working.
    As of now I am using the following pipeline -

    In the mapper snap I have mapped the contact and the account fields both and in the upsert snap, I have selected Contact as the object type and in the related object and field it was Account and External Id field respectively as suggested by the comment.

    I also tried inserting the account first and then again reading the data from csv to insert the contact.

    But the account insert snap and the file reader snap are not getting joined maybe because the output from insert snap is not a valid one for the file reader snap.

    Is it possible if you can share the pipeline with me for reference?