Forum Discussion
Power Query - String as Table name
Hi, In Power Query how can I call a Table name in a function by using a concatenated text sting. e.g : Table1 = Table.FromRows({{1,2}},{"a","b"}), Sufix = "Table" Index = "1" I want to refer to Table1...
Hi Wyn, thanks for your help. That works only whith the "Excel.CurrentWorkbook" function. My table isn't in a Excel Sheet. I need a query witch in is possible to select a table with a parameter as show in the eg attached. Where SelIndex is a parameter list (1,2,3). But in this eg, the query return only the table name, not the table.
Deleted
Here's an option
let
MyTableRecord = [Table1 = Table.FromRows({{1,2}, {"a", "b"}}),
Table2 = Table.FromRows({{2,3}, {"a", "b"}}),
Table3 = Table.FromRows({{3,4}, {"a", "b"}})
],
TableSelect = Record.Field(MyTableRecord, "Table" & Text.From(SelIndex) )
in
TableSelect
I have to thank Imke https://www.thebiccountant.com/ for this approach
- Hi Wyn, Thank for this option but that's what I try to avoid. I want to extract a multi-level BOM from our PDM system in Excel. The data come from a parent/child relationship table. To do this you have to extract the BOM from the final item, then from each of its components and so on to the lowest level of the structure. Every BOM of each component can be considered as a separate table. My idea is to store each of these single tables in a list using the "List.Generate" function. Then build the arborescence of the BOM, by structuring the tables of this list. I have tried to understand the "List.Generate" function. It is quite simple to produce a list of "Records". But if converting a three rows and two columns table into "Record" is simple, it is much harder when you have dozens of rows and columns. The problem is that I don't know how to index the tables like it's possible for "Records".
- Unfortunately I'm out of ideas. Don't know if this is relevant, but this sort of thing sounds like like the type of issue Chris Webb tackles
https://blog.crossjoin.co.uk/2013/06/22/flattening-a-parentchild-relationship-in-data-explorer/- Thanks Wyn, but that's only useful after extracting the data. I have first to find the good query. But I will try some different ways. I keep you informed.