For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

Показать описание

Please note that I have received feedback on the performance with this technique, as slow.
I have used it with small data sets like in the example that I presented, and works fine.
But, please keep that in mind.
Thanks for watching 😊

Working file is available here:

Alejandra Horvath

Рекомендации по теме

Комментарии

Very nice! While I love my Lookups, this is much simpler, and because it's done at this level, much more performative! Thanks as always for teaching us something new!

mathewrtaylor

Reporting back! I AM SO EXCITED! I was cautiously optimistic as other similar solutions really slowed down my query, but NOT THIS ONE! Bravo! 🎉 Thank you!

CAKimberlyLewis

Justo hace un par de semanas estaba buscando una alternativa como esta para una tabla en mi trabajo. Muchas gracias por compartir tus conocimeintos.

ALeKsV

Extraordinario video, como siempre un gran aporte. Gracias y saludos Ale.

eduardomunoz

it's an awesome video, hermoso video Dona Alejandra

danilomassarelli

Excellent! Thank you for sharing! Salvo nos favoritos! You're great!

raimundojs

Very creative! So excited to try this!

CAKimberlyLewis

Interesting approach. Thanks for sharing.

VictorHugo-bdbf

Me gustó! Gracias. A ponerlo en práctica!

joselencinamalgor

Really useful video, thank you!

Do you know how the processing speed of this method compares to merging tables when you are dealing with large datasets?

mosesvaughan

Really great 👍, what kind of merge is it? Is it a left outer?

mecorowa

Great tip, is there an advantage of doing this compared to the merge?

RonDavidowicz

Coming from LinkedIn & I'd like to thank you again

khaledsolieman

What if the column you are using for matching is not unique on the DIM table? WIth Table.AddColumn, you get an error, as opposed to in Excel, VLOOKUP will return the first matching record. How can I duplicate that behavior in PQ?

fvcerullo

Can i do like excel : put condition if results not exist in table go to another table to bring results ??

SamehRSameh

Does this perform better than merging for larger data sets?

edsta

For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

Tips for working with small datasets

Using Small Datasets

Overcoming Issues with Small Data Sets when Building Machine Learning Models

Designing Efficient Deep Learning Models for Small Datasets

ML for Medicine with small datasets

5 Machine Learning BEGINNER Projects (+ Datasets & Solutions)

An introduction to machine learning on small scale datasets, Conor Lynch

Grokking: Generalization beyond Overfitting on small algorithmic datasets (Paper Explained)

The Elephant in the Room: How Data will be AI’s bottleneck - An Everyday AI chat

Machine learning materials properties for small datasets: Poster Pitch

The Case for Small Data Management

Utilizing Generative Deep Learning on Small Datasets - Honours Seminar

Median For Small Data Sets

Increase ACCURACY of Model on Small Dataset | DATA AUGMENTATION for Small Image Dataset

Synthesising images from small datasets - FastGAN-pytorch!

5 Ways to Organize Information For Small to Large Data Sets

[ECCV 2022] Multi-Domain Multi-Definition Landmark Localization for Small Datasets

Image Processing with small datasets

Vincenzo Crescimanna - Train Object Detection with Small Datasets | PyData London 2022

For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

Tuesday Tech Tip - Cyber Security with Small Data Sets

How to access datasets on Kaggle to build your machine learning models?

TOXBANK Tutorials: Upload unformatted data (small data sets)

Entering Small Data Sets into the Casio Calculator