I just realized I forgot to push you the query the other day 😞
HiLorenzo , I tried to do the same manually for the Record you mentioned , for ~6 Records, Expected result in Attached "Anupam_Expectation"sheet. Used a Unique Identifier "CB Index" CB-> # and TB Records
Thanks in Advance,
Br,
Anupam
I just realized I forgot to push you the query the other day 😞
HiLorenzo
Greetings!
I tried to use this calculator again, but seems not working, attached is the raw txt file.
While changing the source, it's giving an err:-
Can you please help on what wrong I am doing?
Thanks in Advance,
Br,
Anupam
I tried to use this calculator again, but seems not working, attached is the raw txt file
As I earlier mentioned your initial call for help required significant analysis, before putting in place a non-trivial query that was based on the file you shared at that time. So, IF the new text file isn't formatted exactly the same, new analysis + query update (or totally new one) are probably required
While changing the source, it's giving an err:-
Your screenshot doesn't show the error in Power Query but it seems obvious you have to update the file path in Excel as it still points to my PC folders' structure
That's all I can do for now (didn't download your file) as my PC died a few days ago and the new one hasn't landed yet
