Forum Discussion

the_pan_zone's avatar
the_pan_zone
New Contributor
4 years ago

How to get value based on a incoming document

Hi, I have the below input data AccountName,AccountID,PAccountID Abc,5467,6000 dsd,6000,7000 dfghyh,7000,5467 In the output I want the Parent account name based on the input so the output w...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @the_pan_zone,

Here’s a pipeline that does exactly what you need:

Inherit Parent AccountName_2021_12_01.slp (5.7 KB)

If by any means, there is a mistake in your CSV sample, because as @smudassir said, the child appears before the parent, and you need it other way around, than you need to change the Mapper expression to :

$input0.map((x,index)=> index == 0 ? x.extend({"PAccountName":$input0[$input0.length -1].AccountName}) : x.extend({"PAccountName":$input0[index-1].AccountName}))

Regards,

  • the_pan_zone's avatar
    the_pan_zone
    New Contributor
    4 years ago

    Thanks @bojanvelevski
    it is working…Do you think it will work for .1 million records?

    • the_pan_zone's avatar
      the_pan_zone
      New Contributor
      4 years ago

      Hi @bojanvelevski ,

      If I add one more row and change the source data
      AccountName,AccountID,PAccountID
      Abc,5467,6000
      dsd,6000,7000
      dfghyh,7000,5467
      new,5000,5467

      This time the code is not working

    • bojanvelevski's avatar
      bojanvelevski
      Valued Contributor
      4 years ago

      It’s hard to tell, theoretically it will work, but you’re sending 1 million records in one array, so I would say it depends on the records?

      The solution is not hardcoded, it’s designed to dynamically add the new field:

      Re-check the setup of the pipeline.