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
Hi @bojanvelevski ,
Please check the 3rd row in your result set.
Here PAccountName should be ABC instead of “new”. PAccountName should not be the next one it should depend on PAccountID. As PAccountId is same for both 3rd and 4th row so PAccountName should be also same i.e. Abc for both 3rd and 4th Row.
Ah, this clarifies things. It was a misunderstanding, the expression you need to use is the following:
$input0.map((x,index)=> x.extend({"PAccountName":$input0.filter(y=>y.AccountID == x.PAccountID)[0].AccountName}))
