days between same material ID

[J_S]

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

[FinnCharlton]

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.

[J_S]

will try this one out, thank you :)