Forum Discussion
How do I append two sources in DAX code instead of the append button?
For the last column that has a different name, you want to combine them into the same column after appending or into two columns with their own names? If you want to combine them into the same column, you need to rename either of them because the Table.Combine() functions works based on the column names. If you want to have them in different columns, I think that is currently what Table.Combine() does. I haven't met the scenario that it would lose the second table that has different column names.
I want to the same column and I want to use the name of the first source as the column header.
so possibly a code before the combine.tables line that changes the name of certain columns in the 2nd source if you can write out a code like that for me.
Please try this
RenameColumns = Table.RenameColumns(#"Converted to Table2", {{"revenueamount", "conversionamount"}}), CombineTables = Table.Combine({#"Converted to Table", RenameColumns}),Hi, this didnt work, do you have to expand first or something?
It says column not found but I know column exsists in the source 2, it gives me the error in the rename columns part.
Can you rewrite this?
let
Source1 = Json.Document(Web.Contents("https:/--Source1urlhere--account_name&_renderer=powerbi")),
Source2 = Json.Document(Web.Contents("https:/---Source2urlhere--account_name&_renderer=powerbi")),
#"Converted to Table1" = Table.FromRecords({Source1}),
#"Converted to Table2" = Table.FromRecords({Source2}),#"RenameColumns" = Table.RenameColumns(#"Converted to Table2", {{"account_name", "account_name"}}), GIVES ME AN ERROR HERE
#"CombineTables" = Table.Combine({#"Converted to Table1", #"RenameColumns"})
in
#"CombineTables"The first name should be the old column name existing in the second table to be changed, and the latter name is the new name for it. If it says column not found, it means that it cannot find the first name from #"Converted to Table2".