Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

Moving the data to new column based on empty row

SH_94
11 - Bolide

Dear community,

 

Would like to seek for help on how to moving the data to new column for the example below: The concept is if the column under GL is empty ( it may have multiple empty rows), then the extract the data from the first empty row in the description column copy to new column called " Remarks". 

 

SH_94_0-1663911763128.png

 

SH_94_1-1663911789809.png

 

 

Many thanks

2 REPLIES 2
binuacs
17 - Castor

@SH_94 One way of doing this

 

binuacs_0-1663917127182.png

 

SH_94
11 - Bolide

Thank @binuacs  for the great idea on how to massage the data . I understand the concept and will apply it my cases.

 

 

Thanks again for the sharing.

Labels