days between same material ID

Question

Hi, I am new to Alteryx. I have created a flow to extract data from excel files. There are chances that the material ID can occur on the following week. I want to create a flow if the Material ID exists and then the number of days between the current date and the last time the material was loaded. I am sorry if my requirements are confusing.

Thank you

J_S · Answer

will try this one out, thank you :)

FinnCharlton · Answer

Hi @J_S ,

You can try something like this:

The multi-row tool calculates the number of days since a Material ID last occured.

If you need any more help please provide some more specifics, and maybe some sample data.

Days Since Last Occurance.yxmd