Arranging the tables

[amitsingh88]

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.

[Qiu]

Hope I understand your request correctly.

[amitsingh88]

No,

result should be like this-

Thanks

[Qiu]

@amitsingh88 
Sorry for not fully understanding it.

Lets use many joints.

[ncrlelia]

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

[atcodedog05 · Accepted solution]

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 : )

[amitsingh88]

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