Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
162
Views
Topic starter
Hi,
I've just watched the Data Cleaning video which will be a god send when I start using it. Thank you.
However, I also need to normalise multiple CSV files for loading to a database (MS SQL). Is there an easy way to do this using Power Query?
Many thanks and best regards
Sean007
Posted : 01/11/2024 4:43 pm
Hi Sean,
Normalization usually means splitting data into multiple related tables, this is what you want to do?
Because most databases have unique structures, there is no template to split data, you will have to create a query for each output table you need.
Posted : 06/11/2024 1:44 am
