SOLVED
Append tools?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Gualigee
8 - Asteroid
11-16-2020
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
do you know what the same process of append tools of Alteryx is in Power Query? Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Topic of Interest
4 REPLIES 4
dougperez
12 - Quasar
11-16-2020
01:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
11-16-2020
01:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @dougperez ,
Thank you for your reply.
But the two sheets just joined together. For instance, I want each category appends 4 quarters:
dougperez
12 - Quasar
11-16-2020
11:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ok, then:
1. Create a collum with null value in both tables
2. Merge the Tables with the new collumns (join the two tables with the null value)
3. Select the correct collumns and data types
4. Okie dokie finished
11-17-2020
03:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. it works 🙂