Alteryx Workflow

[anupgupta12]

Hi There!

I have a data set wherein first column has 1000 records and second column also has 1000 records but data is starting from 1001 row in 2nd column, so in 2nd column first 1000 rows are either null or blank , how can I make sure that, in 2nd column also data starts from row1 using alteryx.

For instance:-

Column1  Column 2

1

2

3

4

                 1 

                 2

expected outcome

col1  col2

1        1

2        2

3         3

Thanks in advance.

[vizAlter · Accepted solution]

Hi @anupgupta12 — Try this solution:

[Qiu · Accepted solution]

@anupgupta12 
I made two sample flows and the second one is more dynamic and will work even the fields name vary each time