We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Row To Column

Ekmi9
8 - Asteroid

Hello Everyone,

 

I have one input set like 

 

ABCD
xyz135
opq246
AEFG
xyz71013
opq81114
abc91215
AHIJ
xyz161820
ghi171921

 

and i wanted to convert this into :

ABCDEFGHIJ
xyz13571013161820
opq24681114   
abc   91215   
ghi      171921

 

 

Appreciate your help 

Thanks in advance !

11 REPLIES 11
IraWatt
17 - Castor

Hey @Ekmi9,

Not sure how I would make this dynamic but here is one way of doing this:

IraWatt_0-1653910587229.png

A lot to explain here so if you have any questions or issues please ask :)
HTH!
Ira

FrederikE
11 - Bolide

Agree with what Ira said.

If you need it to be dynamic you can use the RegEx Tool, to identify the Capital letters within the rows and work with that. 

Ekmi9
8 - Asteroid

number of row are dynamic how can we handle that ?

Ekmi9
8 - Asteroid

I have added one tag column like

 

Ektaoza9_0-1653914138270.png

 

 

can we play with that to get the desire output  

Qiu
19 - Altair
19 - Altair

@Ekmi9 
Since you have added the Tag column so we can treat it as the "Group", which leads to a Batch Macro.

We can take the advance of the option of Data Schema Change option to allow the column to be unioned by name.
Then a typical Transpose and Cross Tab operation to group the values together.

20220530-Ektaoza9-1.PNG20220530-Ektaoza9-2.PNG

Ekmi9
8 - Asteroid

Thank you !

 

But I am not able to open this workflow. can you help me on this?

Ekmi9
8 - Asteroid

my Alteryx ver is 2020.2

binuacs
17 - Castor

@Ekmi9 Open with workflow in a notepad++ and change the version to 2020.2

DavidP
17 - Castor
17 - Castor

Hi @Ekmi9 

 

I was playing around with your example to see if I can do it without a macro. I nearly got there with one exception:

 

The 3 numbers highlighted in the results: 17,19, 21 appears in row 2 rather than row 4. 

 

I've added comments into every tool to explain what it does.

 

I'll have a think about how to resolve the highlighted issue.

 

DavidP_0-1653930028894.png

 

Labels