Forum Discussion
rmahadik
4 years agoRegular Visitor
Need help with Comparing primary keys of nested tables
Hi Experts, I got below Decision_Table. I want prepare a comparison report of nested tables in Data_DB and Data_GT column. I am succeded in comparing rows and colums of these tables. Now 1) I wa...
ronrsnfld
Super User
4 years agoIt is difficult for me to decipher what you want from what you have posted. But, so far as your comment about "loops in Power Query", you can effectively do that with the functions List.Generate or List.Accumulate. You can also write recursive custom functions.
rmahadik
4 years agoRegular Visitor
Hi ronrsnfld,
Here I want to compare nested tables mentioned in columns 'Dup_Data_DB' and 'Dup_Data_GT' and istore the difference in new column (as nested table).
Can you advise on how this can be done ?
- ronrsnfld4 years ago
Super User
No, I cannot. Your question is much to vague for me to contribute anything other than a response to your statement about looping and iteration. Perhaps someone else will be able to interpret better.