Arranging the tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a table like this-
And I want to get this table using from above Alteryx-
Salary table is in the attachment.
I've tried with this workflow, but no success. Please suggest the solution.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No,
result should be like this-
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @amitsingh88,
Please see attached my suggested solution.
1. I would start off with Qiu's initial approach. That is to use multiple join to get each student's Salary & Friends ID.
2. Then join the output (from step 1) with Packages table on Friend_ID and ID, respectively to get Salary 2.
3. Sort if required.
Hope this helps.
Cheers,
Lelia
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @amitsingh88
Interesting usecase similar to sql primary keys & foreign keys mapping and this can be interestingly solved in multiple ways.
Workflow:
@Qiu since this has a lot of different approaches this would be great usecase for weekly challenges 🙂
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot. It will work. And yes apt for weekly challenge.😊