Forum Discussion
Add custom column in multiple tables automatically
I have a power BI file with hundreds of tables. In a subset of those tables (all begin with "vw_card_") there is a common column named "spaid". I need to add a custom column to all of those tables that brings in the first 8 characters of the spaid column. Text.Start([spaId], 8). Is it possible to do this automatically or do I have to go into all ~100+ tables and add it manually?
3 Replies
Anonymous ,
This may be a good quick question for ImkeF who is the meister of M.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielFrom my experience there is a very good chance that these tables should be appended together as one before being loaded to the data model. Then you'd also only have to add a column to one table.
Add a column to each of the tables as with an identifier before appending.
I'm not sure how to mass modify a lot of queries, but if you want a combined table of those tables (possibly just with a shared column) you can use the following statement to get a record object of all queries in the current file. Note you can very easily hit firewall restrictions doing this.
#sections[Section1]
