Power Query - Extracting Patterns - Dates & Hash Tags 🦖🦩

Рет қаралды 1,093

Ай бұрын

Part 2 of Pattern Extraction in Power Query in this video i show how you can extract Hashtags and dates from a dataset.
#datavalidation #dataanalysis #powerbi #powerquery #excel #mquery
File
github.com/jbotes/powerbiTuto...
Query Website
powerquery.how/
PowerQuery Book
www.amazon.com/Definitive-Gui...
Noteworthy techniques
- Nested Lets
- Culture Datetime
text.combine
powerquery.how/text-combine/
list.select
powerquery.how/list-select/
text.split
powerquery.how/text-split/
list.distinct
powerquery.how/list-distinct/

Пікірлер: 10

@kebincui Ай бұрын

Excellent as always 👍. Thanks James

@qasimawan3569 Ай бұрын

Great video! Thank you for the tutorial!

@raimundojs9547 Ай бұрын

Excellent!

@juansepowerplatform Ай бұрын

amazing videos. thanks for your hard work in putting these together

@mnowako Ай бұрын

Amazing. Thanks a lot!

@cathrerinezetadrones3169 Ай бұрын

🤌🏾

@jerrydellasala7643 Ай бұрын

The file link is the same file as your last video, and the Table1 table has NO #'s in the "Pattern Sentence" column. Also, not all of the dates looked like dates. Some used /, others used - as a separator.

@basensei8699 Ай бұрын

Hey Jerry! damn wrong file ! i updated it now thanks for letting me know! yes the dates i deliberately made / and - to show that one can pick up both formats with the culture. Those were all dates in format dd/mm/yyyy or dd-mm-yyyy which is the UK Culture setting.