Jul 14 2020 07:52 AM
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 source
I then use Get and Transform to take Tables 1 and 2 and append them into Table 3.
When I built it worked wonderfully. Now I am updating the data in Tables 1 and 2 and click Refresh All but it won't update Table 3. I have tried saving the workbook and then Refreshing. I tried Saving, closing, and then re-opening and refreshing. Nothing I do will get Table 3 to update even though Excel keeps saying "Running Background Query . . . "
If it helps this is using Excel for Office 365 64 Bit
Transform
Thank you
Jul 14 2020 09:09 AM
Jul 20 2020 08:49 AM
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