Forum

What are the differ...
 
Notifications
Clear all

What are the differences between "Combine & Transform Data" and "Transform Data"?

2 Posts
2 Users
0 Reactions
2,273 Views
(@jycccwjc)
Posts: 64
Estimable Member
Topic starter
 

What-are-the-differences-between-these-two-notifications.PNGWhen I get data from the folder with Power Query, I see two options: "Combine & Transform Data" and "Transform Data."

1. What are the differences between these two options?

2. Which approach is better if I have many CSV files under the folder?

 
Posted : 03/08/2022 8:32 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Jim,

I think that's the wrong attachment!

Anyhow, Combine & Transform triggers the combining of the files in the folder into one query and opens the query editor so you can make further transformations. The Transform Data just opens with a list of the files in the folder so you can make transformations before combining them.

Mynda

 
Posted : 03/08/2022 7:47 pm
Share: