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?
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.
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |