Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help re-formatting data to be more useful

SParsons
5 - Atom

Hi - I'm very new to Alteryx and I'm trying to learn through videos and trial and error. I've managed to get my data input in better shape, but I'm struggling with the last step. The boxes in the "timestamp" column are hiding employee names - I'd like these names to be in the "Full Name" column for each of the dates. So the name in the first row should be moved to the first column for Row 2 through 6. Hopefully this makes sense! Any advice on how to shift those data points? 

1 REPLY 1
apathetichell
20 - Arcturus

This assumes you want them a) in your first column (sorry don't remember it's exact name) and b - they are in the timestamp column already (just burried in data). c) there are no people named "first read" in your company/data set.

 

first data cleanse excess white space on timestamp then in your person category

if !regex_match([time stamp],"\d{2}.*") and !contains([timestamp],"first read") then [timestamp] else null() endif

 

should move them over... post some actual data if you need more help.

Labels
Top Solution Authors