Forum Discussion
Create table for each value (error message) from column
Hi Anonymous ,
When you say "a new table is created", I assume you mean a new query is created in Power Query?
Power Query cannot spawn new queries itself.
I'd need to understand a lot more about what you're trying to achieve in order to advise if there's an alternative solution/workaround.
Pete
Yeah query / table... i mean the same.
I have a column. With Error 1, error 2, error 3. Can I create a table/query, which is generated for each error a new table/query from this column? Well I find already a solution, but its not so smart.
Or do you not understand what I mean?
I think I understand what you want, I really need to understand the WHY part of it.
Splitting up tables like this in Power Query for use in Power BI is neither a standard process nor a recommended one. Power BI is designed to have all similar data in a single table coming from Power Query, then DAX is used to partition the data for analysis/display.
If you can let me know WHY you believe you need to physically split up the tables in Power Query, when they contain similar data, then I can advise on whether this is actually the fastest/best route to your desired end goal or not, and probably avoid an XY Problem in the process.
Pete