Power Query - List.Buffer to do a Million row Lookup

In this video i show you how to do a composite key lookup with a million rows of data using List.Buffer.
#dataanalytics #data #datatransformation #mquery #powerbi #powerquery #powerbidesktop #excel #exceltips
File Link
github.com/jbotes/powerbiTuto...
Noteworthy techniques
- list of lists (double list in a list)
- nested lets
List.ReplaceMatchingItems
powerquery.how/list-replacema...
Table.TransformColumnTypes
powerquery.how/table-transfor...
Text.split
powerquery.how/text-split/
List.Buffer
powerquery.how/list-buffer/

[@Back1Ply]

Thanks for this, hope to see more content about List.Buffer & Table.Buffer.

[@mnowako]

Excellent! I couldn’t be more happier to discover your channel!
Each of your videos is a great lesson!
Thanks a lot!

[@qasimawan3569]

Your content is awesome. I'm learning so much and becoming more aware of the possibility of PQ!

[@TutoPlaysAndroid]

Muito bom

[@kebincui]

Excellent as always! Thanks James.

[@elbadlis]

Awesome. Thank you sensei

[@ftmagicart]

Amazing video as usual

[@AnilKumar-vi8oe]

Back with the Bang, Thank you

[@djl8710]

This is great thanks!

[@danielgoncalveslima9350]

List.buffer is cool....

[@FRANKWHITE1996]

You crazy ❤😊

[@mirrrvelll5164]

Nice! I saved this video =) it will come in handy

[@alterchannel2501]

Wow

[@danishnawaz3651]

Awsom, 👌👌 , you are amazing, Kindly do more videos on List Functions.

[@basensei8699]

Thank you, I will

[@SeyPras.]

Will it improve List accumulate function as well if we have a similar list or records?

[@arlanbatrbekov2036]

Yes