Forum Discussion
Ordering a Table from different Datasets
Hi Anonymous ,
Please learn more about append.
The append operation creates a single table by adding the contents of one or more tables to another, and aggregates the column headers from the tables to create the schema for the new table.
When tables that don't have the same column headers are appended, all column headers from all tables are appended to the resulting table. If one of the appended tables doesn't have a column header from other tables, the resulting table shows null values in the respective column.
More details: Append queries - Power Query | Microsoft Learn
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your response. This is very helpful! Now I have one slight issue. All the data I have right now is currently in this form:
| Name | Status |
| Jill | P5: Almost Last Update |
| Jack | P5: Almost Last Update |
| Peter | P3: Almost First Update |
| Casey | P3: Almost First Update |
| Ryan | P2: Near First Update |
| Henry | P6: Last Update |
| Andrew | P3: Almost First Update |
And my issue is that I know there will be data from other P values that aren't showing, so how can I prepare for those?
Hi Anonymous ,
Please learn more about append.
The append operation creates a single table by adding the contents of one or more tables to another, and aggregates the column headers from the tables to create the schema for the new table.
When tables that don't have the same column headers are appended, all column headers from all tables are appended to the resulting table. If one of the appended tables doesn't have a column header from other tables, the resulting table shows null values in the respective column.
More details: Append queries - Power Query | Microsoft Learn
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.