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?
Solved! Go to 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
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.
Hey,
Thanks.I was able to do it by transposing and then joining it.