Download "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: Power Query - Comment Combiner des Classeurs et Feuilles automatiquement.Next video: EXCEL - Conception Tableau de Bord avec Design (Module #2)

EXCEL - Conception Tableau de Bord avec Design (Module #2)

EXCEL - Conception Tableau de Bord avec Design (Module #2)

Channel: Learnaccess

Power Query - Comment Combiner des Classeurs et Feuilles automatiquement.

Power Query - Comment Combiner des Classeurs et Feuilles automatiquement.

Channel: Learnaccess

Office 2010: The Movie

Office 2010: The Movie

Channel: Dennis Liu

How to View Blocked Websites Using a Proxy Server

How to View Blocked Websites Using a Proxy Server

Channel: usemybox

Bureautique

Excel

Pack Office

Word

Access

Powerpoint

Power Pivot

Power Query

BI Desktop

power query excel francais

consolider des fichiers excel

automatiser la consolidation de fichiers

excel power query tutoriel

excel tutoriel francais

excel power query

excel power query tutorial

excel consolider plusieurs fichiers

excel consolider des donnees

00:00:00

hello everyone and welcome to this

00:00:02

new video so today a video

00:00:05

dedicated to a subscriber who

00:00:08

asked me how to

00:00:10

automatically recover data from those

00:00:13

that he is very regularly via via

00:00:17

their PSA other countries so that's

00:00:20

nothing to worry about more and more often there we

00:00:21

regularly have extractions to do

00:00:23

every month and the objective would be to

00:00:26

recover this new source every

00:00:28

month automatically in another and

00:00:29

sisters to then take

00:00:30

friendly cross tables of the

00:00:31

dashboards so we will see here how we

00:00:33

can do that without using a macro

00:00:36

or we will be able to import

00:00:38

data automatically thanks to

00:00:41

browsing since now this tool

00:00:43

is integrated into your excellent since the

00:00:45

2010 version so if you have a

00:00:48

version of excel 2010 or more you have

00:00:50

Norman proof that the wifi is integrated

00:00:51

in your example here I will language

00:00:54

the data of your excellent you have

00:00:56

in the group

00:00:57

recovered and transformed here is here

00:00:59

porter which is now able

00:01:02

to obtain data

00:01:04

from a workbook of a text file of a

00:01:08

bdf from a folder of cases not

00:01:11

to also go to extract and recover

00:01:13

data from a sql server base so there

00:01:15

you could even automatically

00:01:17

connect to on on nère pe to base of

00:01:21

servers on an access database

00:01:23

we can also use the Azure

00:01:25

Microsoft databases we can also use

00:01:27

other sources it is able to

00:01:29

connect to tables of web ranges

00:01:31

so we are going to use so fear that

00:01:33

rice to go and recover data

00:01:36

sources that we extract every month

00:01:39

every week from nerbis so eoe

00:01:44

and that next month

00:01:48

this data can be updated all and

00:01:49

we will thus take a very

00:01:52

simple source here I hope a small export of a

00:01:56

tool to be an expert in undermine it

00:01:58

could be it could be a

00:02:02

file that you have people enter it

00:02:03

doesn't matter here so we have

00:02:06

a table with here a small base of

00:02:08

customers here with numbers of the names

00:02:11

of the first names so I would like

00:02:12

this source

00:02:13

all the month it is an extraction which

00:02:15

is made of a tool giving you its daughter

00:02:17

we see the extract always on the same

00:02:19

number

00:02:20

here the files are called extraction

00:02:22

I would like this file

00:02:24

whatever the pressures that I am going to

00:02:25

do the next month

00:02:26

this data can automatically

00:02:29

replace its

00:02:30

all the wood via therefore seven other

00:02:32

files so for that well we are going to

00:02:34

use therefore prescribed

00:02:36

so I come back in my

00:02:38

recipient file where I will see received the

00:02:41

the document so we are going to go into the

00:02:44

long teeth the data obtain the

00:02:46

data given that those

00:02:47

generally instructions and it pays

00:02:49

it is very often the data either

00:02:51

from an excel workbook in

00:02:52

excel format or from text files

00:02:54

you will also have the possibility

00:02:56

of using to classify excellent

00:02:59

fight recover so we're going to click here

00:03:02

from a folder as soon as I'm going to

00:03:06

click on this button when

00:03:08

Marc arrives he's going to ask you for the path where there is

00:03:10

security that's being put

00:03:13

in place so I know that I have them

00:03:15

position in my office which

00:03:17

is called extraction here that's like that

00:03:20

it's the file that you go where

00:03:22

ask to search every month

00:03:25

generally when we extract

00:03:27

rps ap niva tools always always call it

00:03:29

the same way

00:03:30

so that's it if the file every month

00:03:33

is always called the same and you

00:03:34

always put it in the same place and

00:03:36

automatically it will recover it

00:03:38

systematically so I'm going to make

00:03:39

a door here and now we've told it

00:03:41

which one we have and I'm importing it and there

00:03:45

you go see yapo mercury which is going to end

00:03:48

what a smile there is and which will start to

00:03:53

show you here what they see

00:03:55

in this binder so there is only one

00:03:56

sheet we are going to click on the sheet it

00:03:59

to eelv offered a little overview of the

00:04:01

data which drinks this is done for me it is

00:04:04

my table and well we will tell it here

00:04:05

click and of a transformist that

00:04:06

moreover it is enough that the formats on

00:04:08

my key for curie the advantage is that

00:04:11

behind pasture and allows you to be

00:04:13

able at the same time to modify the

00:04:15

data of your source five years so

00:04:20

here he recovered the the sheet of agreement

00:04:26

here so there we are really in

00:04:28

the editor flowery points here so he

00:04:32

gave as notes of leaves the name

00:04:36

your query the name of collection here we

00:04:38

will try to rename this query

00:04:39

we will call it data data source imports

00:04:44

it has already done steps here

00:04:46

so we recall proof that yes it is

00:04:49

a sequence of steps which will do it

00:04:53

automatically

00:04:54

so the first step he did was

00:04:56

to go here click on a source that

00:04:58

he told you I went to look for an

00:04:59

excel workbook which is in these

00:05:01

waters zre here if you even place it

00:05:03

elsewhere but it just go and do a

00:05:04

copy paste replace it here this path

00:05:06

automatically it will go it will wander

00:05:08

find it okay so they will

00:05:10

just have to replace the the access path

00:05:13

then it went to extract me thanks to

00:05:16

a second step it has did a

00:05:18

slag heap navigation he saw everything that makes up the

00:05:23

methane source here your head in the first

00:05:25

line of your table of agreement

00:05:27

automatically it is tt who

00:05:28

had Internet users who will do a

00:05:30

third step who will put or who will

00:05:32

promote the head

00:05:33

here you see that 21.2 at the head were

00:05:36

promoted as intel of

00:05:38

agreement column so it recovers the data

00:05:41

only from the table is then

00:05:42

automatically only on the part of the

00:05:44

faults or the songs in column abc123

00:05:48

it that is to say everything is a text okay

00:05:50

but automatically it will create that

00:05:52

it's lamentable by quevilly will try

00:05:53

to identify and ip all all the

00:05:57

columns according to the chan which has in

00:06:01

the source so here now he has seen

00:06:03

that the first column is a

00:06:04

customer number he will automatically put it

00:06:05

1 1 2 3 that is to say a

00:06:08

whole number the name always a text

00:06:11

in text so on there the code he put

00:06:13

these numbers so on

00:06:14

there he saw that the date taken from the

00:06:16

source was not a real date it

00:06:18

often stops when we do

00:06:19

rp extractions and well then we are going to

00:06:21

tell him no the airlock to a date and well if

00:06:23

tomorrow I don't want to do it again the same manipulation

00:06:25

we will ask it to format it as a

00:06:27

date we will tell it to replace the

00:06:30

current step and there it will reformat the field

00:06:32

as a date once and for all so that nothing

00:06:33

more than that makes it easy to approach

00:06:35

6 ago 8 1 18th

00:06:38

so here we created steps we

00:06:40

could add a fourth

00:06:42

for him m for example the number of

00:06:45

customers the ungodly if we have the name the

00:06:46

first name

00:06:47

well we could have told him here to

00:06:49

take his 2 columns d 'okay and we

00:06:53

could tell her here she comes from

00:06:57

the east to merge them so here we are going to

00:07:01

link them to merge the columns

00:07:04

okay we are going to tell her to m a little

00:07:08

little space between the first and last name

00:07:11

okay here we are going to give the name to these

00:07:14

new columns we are going to call it

00:07:16

first name last name and we are going to make it so

00:07:24

now they have just created a

00:07:27

column that has been merged by putting the

00:07:29

names but the first names automatically

00:07:31

that is if we want to avoid have an

00:07:33

additional column well we can

00:07:34

we can ask it at the same time to

00:07:38

add a step which allows us to

00:07:39

merge the two so here we are so

00:07:41

it's as if as an atheist it's not

00:07:42

the two it does it alone there you go and

00:07:46

now she comes to this source

00:07:47

I'm going to tell her what we did

00:07:51

is good here after we're going to go to

00:07:53

the closed home tab loaded and

00:08:00

automatic marne it's going to load the

00:08:01

rocket in a sheet of your

00:08:05

binder here which will we put in the name of

00:08:08

the rocket and here we have all the data from your

00:08:11

source so now I save this

00:08:14

workbook ok I'm going to close it so it's

00:08:20

called here it is imported thematically

00:08:22

monstrous given ok now next month

00:08:26

he is here ok I am

00:08:30

now going to do a new

00:08:31

extraction next month

00:08:38

so there is a saying that my next

00:08:41

data has changed I am going to add

00:08:42

a 39th client and I am going to put myself here

00:08:49

to be here autonomy we are going to put here

00:08:53

anything it doesn't matter it is going

00:08:55

to be a little fresh not to make it

00:08:57

generate a video the 120th yellow pages

00:09:00

we are going to put it here well it is a

00:09:02

building date which was worth putting

00:09:04

today's date we are waiting for the

00:09:05

semicolon

00:09:06

even if it is too much 'is a real separable date

00:09:08

it goes there it will format it and we will

00:09:10

do 1001 it matters is then also

00:09:16

again let's admit that the new

00:09:19

attraction the data has changed here there is a

00:09:21

new data and iliad is nevertheless it

00:09:23

doesn't matter I save

00:09:25

ok I will reopen now a bit

00:09:29

gray here is the loving objective I would like

00:09:31

to have some news as soon as I open my

00:09:34

binder here I should tell him so that I

00:09:36

can retrieve the new data

00:09:38

okay so over there here there is more to

00:09:41

tell him now I go to

00:09:42

the given English I update all

00:09:45

your security devices and

00:09:47

automatically you will see it will

00:09:48

add it will relaunch the query is

00:09:53

there it will automatically add me

00:09:55

at the bottom if I am there it even did

00:09:59

the merger of string concatenation

00:10:00

try so here I have a source which will be

00:10:02

secure all the time here as soon as I

00:10:05

make a structure next month well

00:10:06

this source does not automatically

00:10:08

update itself is in the shot everything

00:10:10

could do lamic cross tables

00:10:12

directly and that happens see

00:10:17

dashboard will update itself so

00:10:20

and to modify the rocket but

00:10:22

here we could go to rocket here

00:10:24

property

00:10:26

to check here it was done well

00:10:28

even give me a kill three

00:10:31

took in shadow ise the rocket by

00:10:32

updating soon here is therefore

00:10:37

here a common make a rocket weight

00:10:41

that Ricky will look for extractions

00:10:43

every month here and that this race

00:10:46

since being updated replaced by

00:10:48

his here it does it or if it does it

00:10:52

automatically so here is

00:10:54

the advantage it is that behind

00:10:56

its automated savas tomato sauce

00:11:00

directly here by default the query

00:11:03

it always had a green but you

00:11:05

can here in the table tools so

00:11:07

the planes in four weeks in

00:11:08

table format automatically

00:11:11

so it gave the name of table it is

00:11:13

the name of your query it will also

00:11:15

give it to the name of your sheet and it will

00:11:16

do it alone

00:11:17

okay directly so here you

00:11:22

have here an automatic query

00:11:27

with a source which will satellite

00:11:28

each time the source is changed

00:11:29

every month every week

00:11:31

here's how well how to do

00:11:34

automatic data imports using

00:11:38

a rocket without any macro justin

00:11:40

making a connection with here an

00:11:45

external source there which can be found

00:11:47

anywhere on a cloud on

00:11:49

a network space whatever for curie

00:11:53

will have gone to pick it up where you

00:11:56

left it come on I'll stop there who I'll

00:11:58

tell you very soon on the next tutorial

00:12:00

[Music]

Description:

Dans cette vidéo vous allez apprendre comment il possible, sans passer par une macro et de la programmation VBA, de récupérer automatiquement dans une classeur le contenu d'une source de données provenant d'une extraction. Pour cela nous allons utiliser l'outil de récupération et de transformation intégré dans les Excel depuis 2010 qui est : Power Query Pour se former aux outils bureautiques Excel, vous pouvez consulter ma boutique : https://learnaccess.kneo.me/shop En vous souhaitant un bon visionnage. Learnaccess Formation. ********************************************************************************************************* Utiliser mon lien de parrainage pour acheter un produit Tesla et obtenir des crédits gratuits : - kilomètres gratuits en Superchargeur - des vêtements et accessoires. https://ts.la/jeanpaul673722 *************************************************************************************************************

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Power Query - Comment Importer automatiquement dans un classeur une source d'une extraction externe"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.