Forum Discussion
PeraZo
Helper I
Helper IHow to select columns and Union 2 tables in Power Query
I have 2 tables as below. I want to Union these 2 tables into 1 single table in Power Query. I know that Table.Combine would do this but I believe the column name needs to b...
to know how to do this watch my video
PeraZoHelper I
Helper IThank you for advice.
When I do the append query it is show as below.
I think this happens because the field name is not exactly the same.
I would like to combine the table when the column name is different like above.
It could be workaround when I change the field name but it is tedious when the data is big.
Is there way I can achieve this within Power Query?
