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...
Forum Discussion
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,
Thanks @bojanvelevski
it is working…Do you think it will work for .1 million records?
