Looping through data set
- 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,
Here is my problem which I'm trying to automate using alteryx!
Using my pictures as a reference, I want to take the data set in picture 1 and transform it into picture 2. Essentially, I want the data to be able to move in time, i.e. if the reporting date flicks forward a month, then my data will move forward by one month too.
So I want a workflow that will take the reporting date in pic 1 (i.e. May 2018), then add on a month (like in picture 2). My time series column for June 2018 will now exclude May 2018 and include August 2018. My revenue data will now shift by one cell accordingly.
Is this possible to do in alteryx?
If so, would really appreciate some help!
Cheers,
Tom.
Solved! Go to Solution.
- Labels:
- Preparation
- Tips and Tricks
- Transformation
- 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
Thank you very much!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Next question, how can I make this repeat/loop more than one time?
i.e. repeat for the next 12 months.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Possible to give sample data with desired output ?
