Need to override output data to an existing file

Question

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 · Answer

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

abacon · Answer

@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.

Appending Columns.yxmd