Alteryx designer Discussions

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

Shifting rows containing "00:00:00"

6 - Meteoroid

Hoping this is an easy one for the brilliant minds on here. I am very new to Alteryx and I have some data where the time stamp is in the wrong columns. Is there a way to shift the rows by identifying the contents of the cell?

Highlighted
Alteryx Certified Partner

Hi @lbrehmer,

 

Could you give an example of the output your looking to achieve?

 

Regards,

Jonathan

Highlighted
6 - Meteoroid

I have updated the sample data to reflect what i am trying to do. Basically any cell with 00:00:00 in column Address 4 OR Address 5 needs to shift the whole row over to align with F10 and F11

Highlighted
ACE Emeritus
ACE Emeritus

There may be niftier ways to do this, but the attached will do it brute force:

 

JohnJPS_0-1581706661785.png

Of interest:

  • Basic idea is to Transpose and then use Multi-Row Formula to row-shift before Cross-Tabbing back.
  • One pain point was column data types: I forced everything to v_string with the Multi-Field Formula
  • Another pain point was spaces in the column names - I removed those with the initial select; (otherwise they get replaced with underscores by the CrossTab, which messes up the final Union).
Labels