the_pan_zone
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: How to get value based on a incoming document
Hi @bojanvelevski , if I change the source and put a null in one row AccountName,AccountID,PAccountID Abc,5467,6000 dsd,7000,6000 dfghyh,6000,‘’ new,5000,5467 I am getting the following error in the expression Failure: Cannot access element 0 of ‘$input0.filter(y=>y.AccountID == x.PAccountID)’, which is empty, Reason: Index was out-of-bounds, Resolution: Please check expression syntax and data types. Expected output should be if there is not parent ID then there will be no parent name corresponding that row. Can you please let me know if we can use any null handling here2.2KViews0likes0CommentsRe: How to get value based on a incoming document
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.2.2KViews0likes1CommentHow 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 will be like AccountName,AccountID,PAccountID, PAccountName Abc,5467,6000,dsd dsd,6000,7000,dfghyh dfghyh,7000,5467,Abc Please help me how can I achieve that?6.5KViews0likes10Comments