Is it possible to add start of the week date on excel file using the available tool?
- 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
Let's consider there is sales data that I download each week on Monday and only has two column. Each week I have to open file and add start week date manually.
Here is the data that I get:
Product | sales |
A | $100 |
B | $120 |
C | $500 |
D | $300 |
E | $130 |
Output that I am looking for:
I wanted to achieve the following table each Monday where the Start Week date is added as new column for entire year of 2024.
For the first the week of 03/04/2024 to 03/10/2024, I am trying to get following table:
company | sales | Start Week Date |
A | $200 | 3/4/2024 |
B | $600 | 3/4/2024 |
C | $100 | 3/4/2024 |
D | $150 | 3/4/2024 |
E | $120 | 3/4/2024 |
For the Week of 03/11/2024 to 03/17/2024. I am trying to get following table:
company | sales | Start Week Date |
A | $300 | 3/11/2024 |
B | $200 | 3/11/2024 |
C | $100 | 3/11/2024 |
D | $300 | 3/11/2024 |
E | $500 | 3/11/2024 |
These two output are separate file, which is stored in a folder then I run workflow to read each file.
- Labels:
- Custom Tools
- Dynamic Processing
- Input
- Output
- Regex
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Reading this - I think you want Alteryx to inherrently know which file corresponds to which week (ie 3/4 start vs 3/11 start). that may be possible - but not with the data you've provided. If that is your expectation - is there a syntax to the filenames which would explain which file is which? Is there a starting file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, I want to know Alteryx that the file that I have provided corresponds to the week and then add week start date as new column for that particular file. For example: I got input file now I want output1 that has new column called start week date as 03/04. Next week I will get another input file again add column called start week date as 03/11. In similar way keep adding start week date for rest of the year, once I get the input file. Goal here is to add start week date column for each week for each file but other data remains the same in input file. I have attatched file, hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you for your response, but this doesn't add new column named start week date to the file. This formula is just extracting start week date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you are going to create a rule that says week 1 is 3/4/2024 - and week n is datetimeadd("2024-03-04",(n*7),"days") - then yes this is totally doable. If not - then you need to create some kind of rule of how Alteryx should know that week 1 begins on x day.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@apathetichell I can make 3/4/2024 as week 1. If I do that, what is "n" in this formula datetimeadd("2024-03-04",(n*7),"days")? or how can I use this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What's the naming convenion of your input file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
