SOLVED
Alteryx Workflow
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
anupgupta12
8 - Asteroid
‎05-07-2021
09:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Workflow
2 REPLIES 2
vizAlter
12 - Quasar
‎05-07-2021
11:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎05-07-2021
11:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@anupgupta12
I made two sample flows and the second one is more dynamic and will work even the fields name vary each time
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)