community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Row Data Arrangement

Asteroid

Hello community,  

 

I have a sample data attached to this message. Included is my Input data and the output data. Could someone give me the formula to re-arrange this data and what steps i should use to get exactly like the output data.  

 

Note:  In the spreadsheet, under the Event_type column, an 'Attach' and 'Detach' completes one move.  Therefore, sometimes there could be more and Attach followed by another Attach without a Detach hence we need to show that Attach as a dash(-).   This also applies to Detaches that follow one another.  Please see this in the document.

 

 

 

Alteryx
Alteryx

@EvansM -

 

Here is what I came up with - 

clipboard_image_0.png

 

Attached is the workflow.

Asteroid

clipboard_image_0.png

I am having a problem with this formula here

Alteryx
Alteryx

clipboard_image_0.png

 

I'm just selecting all the text fields that need to replace nulls with "-"

Asteroid

Thanks  a lot

 

Labels