Forum Discussion
Begginer question : Separate tables from one column
Hello everyone, I have a small question.
I got data like this:
Table1
Data...
Table 2
Data..
... Until 6 tables.
Everything is in the same column and my goal would be to make 6 differents queries with their own table. I tried the basic solution to delete rows and keep the table that I want, but obviously it's not very automatic, if I want to add new files in the future it'll not work.
I was thinking of Table.Split but i'm not so sure on how to use it there. Do you have an idea on how I could do to separate the tables? Please
Thank you!!
Here are my data if you want to understand better.
Hi Anonymous,
See attached PBIX file for an example of one way to do it.
May require some tweaking depending on your actual data.
Let me know if you have any questions.
2 Replies
- KNP
Super User
Hi Anonymous,
See attached PBIX file for an example of one way to do it.
May require some tweaking depending on your actual data.
Let me know if you have any questions.
- AnonymousNot applicable
Hello, thank you for your answer!
I could do it and I'm not gonna lie, it's a very smart way to do it, I like it a lot! I'll try to work more on my data and comeback if I see that I have a problem with this.
Thank you a lot!!!