alteryx execute a work flow when met specific condition

[187]

helHI guys,

I want to read data from some input and append to the template file i have,  i want to have below result, can you guys help on how to achieve that?

if input has data 

A	B	C
XX	XX	XX
XX	XX	XX

if input doesn't have data

A	B	C
	No Data

[MatthewO]

Hello @187 :

Attached is an example workflow that demonstrates how you can accomplish this. There is an example with 1 row of data and one with 0 rows of data to illustrate the results. 

I hope this is helpful!

[Jonathan-Sherman]

Hi @187,

I would take the approach of using the count records tool, which creates a record whether or not you have records in your original table, you can use this value to decide how to transform the data:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan