Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Arranging the tables

amitsingh88
8 - Asteroid

Hi,

 

I have a table like this-

 

amitsingh88_3-1628378813187.png

And I want to get this table using from above  Alteryx-

amitsingh88_5-1628378848352.png

 

Salary table is in the attachment.

 

 

I've tried with this workflow, but no success. Please suggest the solution.

 

 

 

amitsingh88_0-1628378239140.png

 

 

6 REPLIES 6
Qiu
21 - Polaris
21 - Polaris

Hope I understand your request correctly.

Capture2a.PNG

amitsingh88
8 - Asteroid

No,

 

result should be like this-

 

 

amitsingh88_0-1628398279247.png

 

Thanks

Qiu
21 - Polaris
21 - Polaris

@amitsingh88 
Sorry for not fully understanding it.

Lets use many joints.

Capture2b.PNG

ncrlelia
11 - Bolide

Hi @amitsingh88,

 

Please see attached my suggested solution.

ncrlelia_0-1628407145868.png

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

atcodedog05
22 - Nova
22 - Nova

Hi @amitsingh88 

 

Interesting usecase similar to sql primary keys & foreign keys mapping and this can be interestingly solved in multiple ways. 

 

Workflow:

atcodedog05_0-1628413280355.png

 

@Qiu since this has a lot of different approaches this would be great usecase for weekly challenges ðŸ™‚

 

Hope this helps : )

amitsingh88
8 - Asteroid

Thanks a lot. It will work. And yes apt for weekly challenge.😊

Labels
Top Solution Authors