Forum Discussion
Add multiple columns in a single step (Power Query)
Hi Anonymous,
To what I could understood you wnat to append columns if you append two columns that have different columns the ones that don't exist in the other table will automaticly be filled with nulls so you don't need to create those addtional columns:
Regards,
MFelix
This post was concurrent with MFelix' post.
Actually I don't understand the requirement, as you can just append tables with different columns.
Null values will be added automatically.
Anyhow if you still want to add multiple blank columns (I hope null is also fine) then you can use Table.SelectColumns with 3rd argument MissingField.UseNull (see bottom query below).
All 4 queries below consist of 1 line each.
Query Table5Columns:
= #table(5,{{1..5}})Query Table1Column:
= #table(1,List.Zip({{1..3}}))Query Appended:
= Table5Columns&Table1Column
Query Table1AddedColumns:
= Table.SelectColumns(Table1Column,Table.ColumnNames(Table5Columns),MissingField.UseNull)
Thanks for an option 😉 works
P.S.
Kinda funny... such a simple task, has to be done with a "workaround"
This is not a workaround, you wanted to add all the values at once so we are grouping 4 steps into one just that.
Is the same that in excel you wanted to add the 4 columns to each table but not doing it mannually you would create a VBA macro to do it right?
I called it "workaround", as the function Table.FromRecords is not adding Columns directly, but rather merges two tables.
Original + newTable.Anyway, it works nicely and what I needed.
Thanks againThis is because Power Query works with tables and not with rows or columns, all your results in power query are always viewed in a table perspective, so all the steps when you add values is allways based on a table function, in this case because you want to add several columns at the same time, so you create the table and then merge it.