Hi ,
local!lastRowDetails: a!forEach( items: ri!testCdt, expression: segment: if(and(fv!item.aId=ri!tData_cdt.id , fv!item.tabId=ri!tData_cdt.tName,), fv!item,{}) )
This is returning 7 matching rows, but i want only the data of last matched row.
Can you you help me in that.
Discussion posts and replies are publicly visible
You can do it without using a loop using something like the below; it's a bit difficult to know if this works as you've not given a structure for your CDTs or any sample data, but this should point you in the right direction.
index( ri!testCdt, max( intersection( wherecontains( ri!testCdt.aId, ri!tData_cdt.id ), wherecontains( ri!testCdt.tabId, ri!tData_cdt.tName ) ) ), null )