Hi
I'm trying to get two sets of data from two tables using LIST ROWS PRESENT. I can get this to work but when I nest an APPLY TO EACH inside another APPLY TO EACH when using ADD A NEW ROW, I get one set of data on one line and the other set of data on another. Is there a way to combine all fields into one string so that I can add them to one new row? I have tried JOIN but I am not sure who to take this and feed it into the APPLY TO EACH / ADD A NEW ROW item.
Many thanks.
Hi @jed76,
Typically the collection functions union or intersection are good expression functions to use to combine sets of data.