Forum Discussion
Dynamic name extraction.
Hello All, I have around 43 tables in power bi desktop which I want to append into one table. But I also want to add a column that has the Table names in it corresponding to each row. I did see ma...
Hi Anonymous
Profiling is easy you can reference this table and add extra column like below.
The transformation could be done in a similar way however I would advise creating a function for transformations.
Another option would be doing all the transformation in dataflows.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi Anonymous
Try something like this.
let
Source = #shared,
#"Converted to Table" = Record.ToTable(Source),
#"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Type.Is( Value.Type( [Value] ), type table) ),
#"Filtered Rows1" = Table.SelectRows(#"Added Custom", each not ([Name] = "Query1")),
#"Filtered Rows" = Table.SelectRows(#"Filtered Rows1", each ([Custom] = true))
in
#"Filtered Rows"
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz thankyou for the solution. It does seem to work but when I expand the value column, it gets stuck after loading around just 190 rows and I have like 45 Tables and stays that way forever:smileysad:. Also I want to remove all the tables after appending them. Just so there is only one main table.
Hi Anonymous
Where do these tables come from?
Many Thanks
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.