Forum Discussion
Einomi
1 year agoHelper V
Auto and Manual Categories
Hi, I download bank statements in CSV formats, and consolidate them in PQ. These are my steps 1. Load folder from SharePoints (using SharePoint.Contents) 2. Make all my transformations then loa...
AlienSx
1 year agoSuper User
Einomi just continue editing your original query statement (using statement(2) and auto). This article by Matt Allington illustrates one of possible self-referencing setup.
Regarding ref: well, Left Anti join may help
Einomi
1 year agoHelper V
Thanks for your answer. I am aware you are quite busy hence the quick reply 😁
However, can I send you my file via DM, because we are so so close and do not want to miss out.
After, I'll make a post to explain to new members or even advanced ones this rocking method 🙂
Please we are so close and I must miss something