Forum Discussion
Reorganized datas from a flat cube
AFAIK There is no way to do it. Power Query certianly cannot. You might be able to script it on Tabular Editor, but that would require you to enable unsupported functions, and any issues (even if possible) will not be supported by MS. They don't support T/E editing M and creating objects.
OK, sorry, that was my first post.
The goal is to transform the "Line items" column into tables containing the others fields (following screenshots)
The source :
What I need:
The first disctinct value (in the black rectangle) becomes the name of a new table containing datas of the red rectangle.
Then next distinct value, until the end.
With the datas below, I should have a bit less than 20 tables at the end.
The result with the first value of Line Items Column:
To complete, here are some datas.
VersionsLine ItemsTimeACTIVITE COMMERCIALE- Détails- Bloc
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
I think it's better to find the solution now.
Thanks to all.
Ludo
Are you wanting Power Query to create those tables? It cannot. Power Query cannot create other objectes (lists, tables, values, etc) - it can only manipulate the data it has. It can convert the existing data into a table, list, or whatever, but it cannot create other objects on that side pane.
If that isn't what you mean, please advise.