Forum Discussion
Excel Get and Transform Refresh does not Refresh
Good Morning, I have an Excel workbook. It has 3 tables. Table 1 I populate by cutting and pasting data from 1 data source Table 2 I populate by cutting and pasting data from a different data ...
Check the definition of the append is correctly pointing towards the pasted data. Are you sure that you are pasting into the Tables themselves, and not pasting over them? If you pasted over them, the Append query would not work.
If you're able to attach your workbook to your post, I'll take a look at it.
If you're able to attach your workbook to your post, I'll take a look at it.
Good Morning OwenPrice,
Thank you for the offer to review it. I kept at it and was able to get it to work.
In case anyone needs a simple way to append 2 tables here is the Let statement.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Appended Query" = Table.Combine({Source, Excel.CurrentWorkbook(){[Name="Table2"]}[Content]}),
#"Changed Type" = Table.TransformColumnTypes(#"Appended Query",{{"Field01", type text}, {"Field02", type text}, {"Field03", type number}, {"Source", type text}})
in
#"Changed Type"Sample workbook attached. It takes the data from Table1 and Table2 and combines them into Table 3. Then a pivot table sourced from Table3 to do whatever analysis you need.
Thank you.
Barclay
