Get the data from the most recent file in a folder with Power Query

Share this & earn $10
Celia Alves - Solve & Excel
Published at : 01 Jan 2021
924 views
19
0

This video how you can connect an Excel file to a folder with Power Query and bring the data of the most recent file in that folder into Excel. The particular situation used in this video also includes an example of how you can apply a left outer join to consolidate your data.

Previous video: https://youtu.be/Cfod_PUNWFo

Playlist “Excel and Power Query” – https://www.youtube.com/playlist?list=PL-UOviQH8I1VTbGkpZdxI3DlH00wprx7a

Subscribe to the channel - https://www.youtube.com/channel/UCzWFp4hOnIBHHCJi_SEWV7g

Intro videoclip by Daniela Alfarrobinha – https://vimeo.com/danielaalfarrobinha
Excelsolveandexcelmississaugabiz

UMass Boston Office for Faculty Development Launch Celebration

UMass Boston Office for Faculty Development Launch Celebration

Encore moins cher que le discount : qui sont les nouveaux casseurs de prix ?

Encore moins cher que le discount : qui sont les nouveaux casseurs de prix ?

FIT INDIA MOVEMENT ( QUIZ COMPETITION)

FIT INDIA MOVEMENT ( QUIZ COMPETITION)

MXGP Video Game - How to scrub - Motocross

MXGP Video Game - How to scrub - Motocross

Politicalstation 5: Kokatu reviews the PS5 In the worst way possible

Politicalstation 5: Kokatu reviews the PS5 In the worst way possible

Checking Out Me History Analysis Grade 9

Checking Out Me History Analysis Grade 9

Spirited Away - Official Trailer

Spirited Away - Official Trailer

Sick Song | CoComelon Nursery Rhymes & Kids Songs

Sick Song | CoComelon Nursery Rhymes & Kids Songs

TÜM RUHSAL SIKINTILARI GİDEREN O SURE (NECM SURESİ) | ABDURRAHMAN EL USSİ

TÜM RUHSAL SIKINTILARI GİDEREN O SURE (NECM SURESİ) | ABDURRAHMAN EL USSİ

Difference between "WHILE" and "DURING" [ ForB English Lesson ]

Difference between "WHILE" and "DURING" [ ForB English Lesson ]

Introduction to 28 Days of Weight Loss - Loren, Dennis, Dr. Dee, Melanie, & Sosan

Introduction to 28 Days of Weight Loss - Loren, Dennis, Dr. Dee, Melanie, & Sosan

Lena Dunn Community and Service Parade 2020

Lena Dunn Community and Service Parade 2020

Sen. Harris: Committee is determined to rush Supreme Court confirmation through

Sen. Harris: Committee is determined to rush Supreme Court confirmation through

CLOTHING TRY-ON HAUL ft. SHEIN! (Perfect for CHUBBY GIRLS) | Philippines

CLOTHING TRY-ON HAUL ft. SHEIN! (Perfect for CHUBBY GIRLS) | Philippines

When you bump into a demon girl

When you bump into a demon girl

Tristen "Eager For Your Love"

Tristen "Eager For Your Love"

THIS IS WHY MUSLIMS HATE PORK | Is Pig Meat Unhealthy ?

THIS IS WHY MUSLIMS HATE PORK | Is Pig Meat Unhealthy ?

Pick My Load - EXPERIENCE A HASSLE-FREE MOVE

Pick My Load - EXPERIENCE A HASSLE-FREE MOVE

REVALS - Must

REVALS - Must

ASMR EDIBLE SLIME, HAIR BRUSH, TIK TOK FRUIT JELLY, JELLO POPSICLE, PURPLE FOOD, CANDY MUKBANG 먹방

ASMR EDIBLE SLIME, HAIR BRUSH, TIK TOK FRUIT JELLY, JELLO POPSICLE, PURPLE FOOD, CANDY MUKBANG 먹방

Nicole Cross - Loosen Up (OFFICIAL VIDEO)

Nicole Cross - Loosen Up (OFFICIAL VIDEO)

TES generators and motors - Production of electric machines

TES generators and motors - Production of electric machines

When The Narc Gets The Opportunity To "Cross Examine" You In Court! (DO THIS!) // HEALINGDAYBYDAY

When The Narc Gets The Opportunity To "Cross Examine" You In Court! (DO THIS!) // HEALINGDAYBYDAY

Roy Baumeister on Self-control & Willpower

Roy Baumeister on Self-control & Willpower

MEGHAN TRAINOR - FOOLISH (Audio)

MEGHAN TRAINOR - FOOLISH (Audio)

Timeflies - Gravity (Official Video)

Timeflies - Gravity (Official Video)

Category Is: Best Drag on the Runway (Compilation) | RuPaul’s Drag Race

Category Is: Best Drag on the Runway (Compilation) | RuPaul’s Drag Race

ನನ್ನ ಅಮ್ಮನಿಗೆ ನಾನು Love marriage ಮಾಡ್ಕೊಂಡಿದ್ದು ಬೇಜಾರು ಇದ್ಯಂತೆ😭 QnA with my parents | Kuku playing🐶

ನನ್ನ ಅಮ್ಮನಿಗೆ ನಾನು Love marriage ಮಾಡ್ಕೊಂಡಿದ್ದು ಬೇಜಾರು ಇದ್ಯಂತೆ😭 QnA with my parents | Kuku playing🐶

Peter Mottishaw: Finite size effects and replica symmetry breaking; ...

Peter Mottishaw: Finite size effects and replica symmetry breaking; ...

APUSH Review: Key Concept 7.3, revised (Most up-to-date video)

APUSH Review: Key Concept 7.3, revised (Most up-to-date video)

รีวิว Wharfedale DENTON 85th Anniversary คู่กับ Marantz PM8006 และ ND8006

รีวิว Wharfedale DENTON 85th Anniversary คู่กับ Marantz PM8006 และ ND8006

Aluminum-free & Natural Deodorants || A Comprehensive Review & Comparison

Aluminum-free & Natural Deodorants || A Comprehensive Review & Comparison

Seager, Buehler help Dodgers push NLCS to a Game 7 | Braves-Dodgers Game 6 Highlights 10/17/20

Seager, Buehler help Dodgers push NLCS to a Game 7 | Braves-Dodgers Game 6 Highlights 10/17/20

A Woman Enslaved By An Internet Predator At 13 Shares Her Ordeal | The Oprah Winfrey Show | OWN

A Woman Enslaved By An Internet Predator At 13 Shares Her Ordeal | The Oprah Winfrey Show | OWN

N41 discussion with Jim Leishman - Revised with additional discussion regarding stability added

N41 discussion with Jim Leishman - Revised with additional discussion regarding stability added

𝓭𝓮𝓶𝓸𝓷 𝓲𝓷 𝓪𝓵𝓵 𝓪𝓵𝓹𝓱𝓪 𝓼𝓬𝓱𝓸𝓸𝓵 (1/?) ❤️ (𝓖𝓛𝓜𝓜)

𝓭𝓮𝓶𝓸𝓷 𝓲𝓷 𝓪𝓵𝓵 𝓪𝓵𝓹𝓱𝓪 𝓼𝓬𝓱𝓸𝓸𝓵 (1/?) ❤️ (𝓖𝓛𝓜𝓜)

How to tikyok can get money 💵 all my friends very useful videos all my brother rohingya and sister

How to tikyok can get money 💵 all my friends very useful videos all my brother rohingya and sister

Reward for info on ice cream vendor's killing now up to $24,000, thanks to community groups

Reward for info on ice cream vendor's killing now up to $24,000, thanks to community groups

FiRST Family Beach Vacation!! (1/5)

FiRST Family Beach Vacation!! (1/5)

on the other hand  エレクトーン  ELS-02cVer.

on the other hand  エレクトーン  ELS-02cVer.

Lords Mobile - Petite Devil Limited Challenge Stage 4 (2020)

Lords Mobile - Petite Devil Limited Challenge Stage 4 (2020)

Gemini  🔮 What You're NOT EXPECTING To HAPPEN‼️ ⚠️ October 21-31

Gemini 🔮 What You're NOT EXPECTING To HAPPEN‼️ ⚠️ October 21-31

SHOCKING: 4 Year Old Trans Child on New HBO Series | WATCH

SHOCKING: 4 Year Old Trans Child on New HBO Series | WATCH

It Passed Over Me

It Passed Over Me

Experience - Ludovico Einaudi | AKADEMY Dance Company

Experience - Ludovico Einaudi | AKADEMY Dance Company

磁気嵐発生中 🌈 magnetic storm is occurring

磁気嵐発生中 🌈 magnetic storm is occurring

NEW Star Wars Archives: Eps I-III: 1999-2005 by Paul Duncan - Unboxing by Author

NEW Star Wars Archives: Eps I-III: 1999-2005 by Paul Duncan - Unboxing by Author

Destiny - Animation Short

Destiny - Animation Short

How to Assemble SmartDesk 2  | Autonomous Desk Manual

How to Assemble SmartDesk 2 | Autonomous Desk Manual