Need to override output data to an existing file

[Sameer_Kanade8810]

Hi All I am gona run a workflow which will give me below Data. I am gonna get this output daily.

PROCESS COUNT
CARDS        1

CARS           2

BUS             3

What i need a master file which will be saved in some xyz location like below.

Process  4/22/2025  4/23/2025
Cards       2                    1
Cars         3                    5

Bus          5                    6

Once i run the workflow the top table data should be added next to the 04/23/2025 it should look like this.

Process  4/22/2025  4/23/2025  4/24/2025
Cards       2                    1             1
Cars         3                    5             2

Bus          5                    6              3

Is this possible. using alteryx.

[abacon]

@Sameer_Kanade8810 Here is a workflow that does it. Treat the tools in the container as the original data source that will get run through the workflow everytime. The join should have unknown selected.

[abacon]

If this worked for you, please mark it as the solution! @Sameer_Kanade8810