GETTING VALUE FROM TWO EXCEL SHEET

[simran2003]

I WANT TO DISPLAY ALL THE CITY FROM SCREENSHOT 2 DEPENDING UPON THE COUNTRY GIVEN IN SHEET 1.HOW TO CONNECT BOTH OF THESE EXCEL SHEET?

[DiegoParker · Accepted solution]

Hi Simran,

Is there any chance you can upload a workflow? You will need to do some data prep. You will have to do some transpose in your second sheet and then when you get it to the correct format you will have to join them by country.

Have a look at transpose tool here https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Transpose/ta-p/89741

and join tool here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Join/ta-p/29814

Hope this helps.

Best,

Diego

[CharlieS]

Hi @simran2003 

To outline how this could go, we need a clear idea of what you'd like the output to look like. Could you put together an example of this? Also, if you're able to attached some sample data, that always helps the Community in building solutions. 

[simran2003]

Hey,

Thanks.I was able to do it by transposing and then joining it.