Hi There,
I am new to Alteryx. I have a scenario where I have to extract last month Data and show the same data for the current month and for the next 6 months changing couple of fields. I am pretty comfortable in SQL Server where I will write a loop to insert by selecting data from last month and change the date in select columns.
Example:
FirstDayMonth ID A/B Count
7/1/2018 1 B 170
8/1/2018 1 B 165
9/1/2018 1 A 165
10/1/2018 1 A 165
11/1/2018 1 A 165
12/1/2018 1 A 165
1/1/2019 1 A 165
2/1/2019 1 A 165
3/1/2019 1 A 165
Current Date is 9/20/2018. So I have to pull 8/1/2018 and change B to A and show same count for 9/1/2018 till 3/1/2018. Please suggest
Solved! Go to Solution.
Hi
This will do what you're looking for.
Assuming your input is something like this with previous months data
This workflow will generate new dates for the current and next 6 months, fill in the proper values and append the data to the input rows
It actually gets the last valid date from the input data, so if the previous month's data is missing, it will use the one before.
Dan
Thank you Dan. That worked!!
If you're happy with it, please consider marking it as a solution
Thanks
Dan