Forum Discussion
Append Table Not Appearing
Dear Community Could you please help me with the following. I have appended 6 tables that have the same underlying excel format but the new appended table is not appearing. I am not getting an er...
- Aha, ok. I get your problem now.
You have done 'Append Queries' this time, so all the data should be loaded into the Alpine - Progress table.
If you want a new table of all Appended, you need to select 'Append Queries As New' from the drop down arrow on the Append Queries button.
The missing table is the newly created table, the output from the Append Queries. When I tested this Append Queries feature with 2 tables an additional table appeared called APPEND1 appeared in the left panel. Is this where I should be looking to find the newly created Append table?
I used the Get Data feature, but in PowerBI. I changed some columns data type to Text or in some cases Decimal Number (Percentage) where it was more suitable than the suggested data type. I did this on all the 6 tables, and then completed the Append Queries process.
Thanks Alison
Aha, ok. I get your problem now.
You have done 'Append Queries' this time, so all the data should be loaded into the Alpine - Progress table.
If you want a new table of all Appended, you need to select 'Append Queries As New' from the drop down arrow on the Append Queries button.
You have done 'Append Queries' this time, so all the data should be loaded into the Alpine - Progress table.
If you want a new table of all Appended, you need to select 'Append Queries As New' from the drop down arrow on the Append Queries button.