General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Grouping data from a table

ANANDPRABHU
6 - Meteoroid

Hi Team, I need help with an Alteryx workflow for the following input and output as listed.

 

Input:

COL1COL2COL3COL4
235636235365
652896456326
896999777555
33355533344

 

Output: (can be any order)

235
636
235
365
333
555
333
44
652
896
456
326
896
999
777
555
2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @ANANDPRABHU 

 

You can use Transpose tool to convert columns to rows.

 

Workflow:

atcodedog05_0-1626890169092.png

 

Hope this helps : )

 

ANANDPRABHU
6 - Meteoroid

Thanks All, it worked.

Labels