Transpose logic

Question

Team,

Need your help in developing below logic in Alteryx.Thanks in advance.

I/P:

City1City2City3City4    ChennaiDelhiMbiKolkata   Temp35233031   Humidity99989796   Airflow55666666

O/p:

TempChennai35  TempDelhi23  HumidityChennai99  HumidityDelhi98  AirflowChennai55  AirflowDelhi66

aatalai · Answer

@susukavi the attached workflow should do the trick, showed you 2 different methods, please let me know how you get on

Transpose logic.yxmd

Genevieve · Answer

Hi @susukavi

Once you have transposed, separate the row which has the names of the cities before mapping them with a Find/Replace.

KGT · Answer

What have you tried? Do you have a workflow with your data in it?

This is a simple transpose and so if I was to build a workflow to show, it wouldn't match your data. You have blank rows on the Input and then no headers on the output and so cleansing the headers would be the bulk of it. Then there's 2 messages of back/forth... all for a one tool solution.

Transpose. All you need to do is remove the line that has City in it, and make the cities the headers.