Alteryx Designer Desktop Discussions

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

How to reorder a column

ARAJPUT_HENRY
6 - Meteoroid

Hello -

 

I have a column like below-

null

2

3

4

null

2

3

4

5

6

7

8

null

2

3

4

5

6

8

 

I want to reorder the column . See in the last, 7 is missing. So which tool will be suitable to fix . If multiple row formula then what will be the configuration /formula.

Thanks in Advance  

8 REPLIES 8
binuacs
20 - Arcturus

@ARAJPUT_HENRY Use the multi-row formula tool

binuacs
20 - Arcturus

@ARAJPUT_HENRY One way of doing this

binuacs_0-1681505070221.png

 

ARAJPUT_HENRY
6 - Meteoroid

Thank you but I will not be getting last digit 8.Its missing . .

binuacs
20 - Arcturus

@ARAJPUT_HENRY Updated workflow attached

 

binuacs_0-1681513210088.png

 

ARAJPUT_HENRY
6 - Meteoroid

Thank you so much for your quick reply and help . I was trying to include workflow in my data but getting duplicate records. I am attaching data sheet. Look at the record ID -1130 to 1134. 

binuacs
20 - Arcturus

@ARAJPUT_HENRY updated workflow attached

binuacs_0-1681733675553.png

 

Christina_H
14 - Magnetar

Here's another option

Christina_H_0-1681735801856.png

ARAJPUT_HENRY
6 - Meteoroid

Thank you so much !

Labels