how to consolidate all file in one file having same column name

(0) Share

Report

Posted on by supriya22

how to consolidate all file in one file having same column name . please guide.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

mmonline 169 on at

Like
a
(0)

Report
Copy link

Link copied!
A couple things:
You posted this twice. You should delete one.
After you delete one, you'll need to provide more context/details.
It seems you are saying that you have multiple files (Excel, text, other data?) with a specific column and you want to read the data from those files and create, or add to, a single file.

If you can provide an example (screen shot) of what the data looks like, what type of files, where they are housed/stored, that information will make providing a cogent answer easier.

Was this reply helpful? Yes No
supriya22 28 on at

Like
a
(0)

Report
Copy link

Link copied!

i have 3- 4 excel files having same column . i want to append data in one file.

Was this reply helpful? Yes No
GULB 13 on at

Like
a
(0)

Report
Copy link

Link copied!

use powerquery i guess!

Was this reply helpful? Yes No
mmonline 169 on at

Like
a
(0)

Report
Copy link

Link copied!
Okay - this will depend on whether the 3 to 4 files will change or not. Is it 3 or 4 files today but could be new files tomorrow? Etc. Lots of variables.

In short,
Open the file the data is going into. (Open Excel instance with master file)
Loop through those 3 or 4 files.. (For Each)
Read the data from the current file
Write the column to the file opened in Step 1
Close the file opened in step 2
Loop to the next file
This is a rudimentary conceptual idea of how you might solve it.

You could put those 3 or 4 files into a folder, which would let you use the actions below to process through those files.

I hope this gives you ideas on how to think about the solution.

Was this reply helpful? Yes No