If row has values, then jump down one row and calculate values there
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Community!
I have values to add each week into one row across a number of columns. If the row already has values in it, I want Alteryx to go to the row below and retrieve values from another sheet and populate that row.
Any ideas how I can do this?
Many thanks!
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Savannah
Interesting scenario can you provide us more detailed info, some files and expected output.
We can help you out best once we have them 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This week, I would like Alteryx to populate row 7 with numbers from a different sheet.
Next week I would like Alteryx to jump down to row 8 and populate that row.
Any suggestions would be welcome! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Savannah,
I would just use a union tool and add this data into the next available row.
I think this would work for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm not sure what you mean, I'm new to Alteryx 🙂 , but I will have a look. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many thanks! I had to add a few more tools, but this helped!
