In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Numbering Duplicate Fields

JakeRysdon
5 - Atom

Hello,

 

Can anyone help make this:

 

123452019-11-30 13:14:00

DR

123452019-11-21 13:31:00DR
123452019-11-12 07:58:00ON
123452019-11-30 10:48:00 ON

 

Look like this:

 

NumberDRDR ONON
123452019-11-30 13:14:002019-11-21 13:31:00 2019-11-12 07:58:002019-11-30 10:48:00

 

I am struggling to get the fields to duplicate like above. I also tried to put numbers on the duplicate fields though I failed to find a workable solution. Any ideas would be appreciated. 

 

Thanks

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @JakeRysdon I mocked up a workflow that produces your output. Alteryx be default does not allow duplicate named columns so you will need to number them if you do have duplicate columns. 

 

Fields_171219.PNG

JakeRysdon
5 - Atom

Thank you, this was helpful.

Labels
Top Solution Authors