Alteryx Designer Desktop Discussions

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

Need to repeat the same user-entered date for all the rows

Gandalf_NotGrey
Asteroide

Hello, I have a workflow where I am taking two user inputs, first is a Bill Number and second is a Date. The user can enter multiple bill numbers separated by a semi-colon, but they only have to select one date, which will be the Month-Year for all those Bills.

How can I build that? Below is a view of what I am trying to do - 

 

User Inputs the Bill Number manually in the Text Box Tool and selects the Date from the Date Interface Tool 
Bill_NumDate
Bill_001;Bill_002;Bill_003;Bill_004:Bill_0051/1/2024

 

Above Date of 1/1/2024 is then copied to each Bill_Num, also the Bill_Num field is also vertical now, instead of Horizontal from before - 

 

Final Result 
Bill_NumDate
Bill_0011/1/2024
Bill_0021/1/2024
Bill_0031/1/2024
Bill_0041/1/2024
Bill_0051/1/2024

 

Thanks.

2 RESPOSTAS 2
alexnajm
17 - Castor
17 - Castor

Append Fields is your best friend here for when you need a value to repeats again and again for multiple rows! But doesn't this value cascade down anyways when you use a Split to Rows option for your data?

Gandalf_NotGrey
Asteroide

Thanks so much @alexnajm 

Enquetes
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Rótulos