Forum Discussion
the_pan_zone
4 years agoNew Contributor
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 here