topic Transpose logic in Alteryx Designer Desktop Discussions

Transpose logic

susukavi — Fri, 04 Jul 2025 04:38:14 GMT

Team,

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

I/P:


	City1	City2	City3	City4
	Chennai	Delhi	Mbi	Kolkata
Temp	35	23	30	31
Humidity	99	98	97	96
Airflow	55	66	66	66

O/p:

Temp	Chennai	35
Temp	Delhi	23
Humidity	Chennai	99
Humidity	Delhi	98
Airflow	Chennai	55
Airflow	Delhi	66

Re: Transpose logic

KGT — Fri, 04 Jul 2025 06:09:54 GMT

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.

Re: Transpose logic

Genevieve — Fri, 04 Jul 2025 13:27:29 GMT

Hi @susukavi

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

Re: Transpose logic

aatalai — Mon, 07 Jul 2025 07:42:09 GMT

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