
Announcements
Hi everyone,
I have the following formula where I use two Forall and I have problems in the second filter not iterating with the value of the first forall, i want to use ThisRecord referring first ForAll in second one.
In red where i want to place my ThisRecord from the first forall but it takes from the second.
Thx
There is a disambiguation operator (@) but I find it easier just to use the RenameColumns function to make the names of any columns that are shared between the two 'collections' unique - e.g. RenameColumns(MyCollection, "ID", "myID") then Filter(MyCollection2, ID = myID).