Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Adding a column

anupgupta12
8 - Asteroid

Hi There!

 

 

I need to add a new column to below data set, Please note below data has counting from 1 to 4 then repeating but my data set keep varying, next month i may have 1 to 5 then repeating.

Data
1
2
3
4
1
2
3
4
1
2
3
4

 

Expected outcome.

DataName
1Data set 1
2Data set 1
3Data set 1
4Data set 1
1Data set 2
2Data set 2
3Data set 2
4Data set 2
1Data set 3
2Data set 3
3Data set 3
4Data set 3
10 REPLIES 10
anupgupta12
8 - Asteroid

Thanks Mike:-) 

Labels