Hi everyone!
There is probably a simple solution for this but I haven't figured it out.
I have a flow that runs data every day. But I would like to track the development of the data on a daily basis. I'm using the summarize tool to get all the average numbers on one record, and it is these average numbers I would like to generate a new record for every day with the current date of the day.
I have played around with the Generate Rows tool but no luck. I guess I just don't know how to use it.
Example:
| Date | Avg number |
Today | 12-11-2020 | 10,5 |
Today+1 | 13-11-2020 | 11,2 |
Today+2 | 14-11-2020 | 10,4 |
Solved! Go to Solution.
@bvj
Is this what you need?
Hey @bvj
A couple things you need to do:
1 stream to build your label (ie Today + x ) : You can take the ordered list, pull the bottom row, get the last character as a number and add 1 then concat "Today+" + tostring(number)
1 stream to get your next date which is just two functions: max(Date) then DatetimeAdd(ToDate(Date()),1,"days")
1 stream to do a average.
Once you have all 3 of these individual numbers, do a join by position to get a single 'new' row and then use the append tool to add to original dataset
Hope this helps!
Thanks. I have applied the solution and will see tomorrow when we have a new date if it works.
(This message is just to be ignored - don't know how to delete it)
Unfortunately it does not work. Today I still only got one line instead of two.
With the right solution I should have two records: One for yesterday (12-11-2020) with the avg numbers for yesterday, and another record with the avg numbers of today (13-11-2020).
My output is a summarize tool with one record that updates every day. I would very much like to record the updated number on a new generated record for every day.
I'm sorry but I don't completely understand your solution, could you provide an .yxmd example? If it's not too inconvenient.
@bvj
If I understand correct, you data updates everyday, so how can we get the data yesterday?
If that is the case, we need to have a Datalake or sort of thing. And if the data is not big, we can export to a Alteryx Database file then retrieve it.
Let me know.
Yes a data lake where we store a new record for everyday. Alteryx database would definitely work as output.
Made a sample flow for your reference.
Basically, the flow will read 'yesterday' data and join with 'today' data then output to update 'yesterday' data.