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.
Solved! Go to Solution.
@anupgupta12
I made two sample flows and the second one is more dynamic and will work even the fields name vary each time