Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Generate matrix (add rows for each unique value)

michaelalexander
6 - Meteoroid

I have a long list of people names in an excel column. I'd like to add rows for each day of the week to each value. Example below. Thank you!

 

Current:

Bill

Frank

Steve
Mike
Hank

  

What I want:

BillMonday
 Tuesday
 Wednesday
 Thursday
 Friday
FrankMonday
 Tuesday
 Wednesday
2 REPLIES 2
NicoleJohnson
ACE Emeritus
ACE Emeritus

If you add a Text Input tool that contains the days of the week you wish to add to each name, then add an Append tool (with the Target input as your list of names and the Source input as your list of weekdays) that should give you the results you are looking for!

 

NJ

michaelalexander
6 - Meteoroid

Thank you NJ!! Much appreciated. 

Labels