How to work with files and change date

Question

Hi

We have many workflows where we condolidate a group of files. And we consolidate all files every time.

This is a big wate of time, since old files rarely change.

Therefor I wanna find a good method where I can consolidate all files in a folder. And the next time I do the consolidation I only add whats new, and remove the old file from my alteryx db - and add it again if changed.

Ex:

And ideas?

atcodedog05 · Answer

Hi @Hamder83

The workflow would be something like this

Hope this helps : )

FLOW.yxmd

FLOW.yxzp

Hamder83 · Answer

Hi @atcodedog05

maybe im missing comething, but I dont see how to solve it correctly. If you have a chance would you take alook at my sample flow, and maybe correct it?

Thank you

FLOW.yxzp

atcodedog05 · Answer

Hi @Hamder83

Just a have separate yxdb file which stores only the last write date this way it always reads only a file which might have only 1 row (last write date)

Hope this helps : )