Generate Output for newly added clients

[julianhoetzel]

Hey guys, 

I have a questions regarding the following topic:

How can Alteryx automatically add new outputs for newly added clients? 

This is the genesis table

Date	Client	Amount
2021-01-01	ABC	10

If a new client XYZ is added like this on date 2021-01-02, I'd like to have both clients automatically separated in two excel sheets or/and two output flows respectively. 

Date	Client	Amount
2021-01-01	ABC	10
2021-01-02	ABC	10
2021-01-02	XYZ	30

... so that I receive the following outputs

Date	Client	Amount
2021-01-01	ABC	10
2021-01-02	ABC	10

Date	Client	Amount
2021-01-02	XYZ	30

Is that possible?

Thanks in advance. 

Cheery

Julian

[atcodedog05 · Accepted solution]

Hi @julianhoetzel 

Configuring your output tool like below will split each client to sheets.

Hope this helps 🙂