Add a new row if condition is correct

[Inactive User]

Hi guys,

I have the following problem, that I want to add an existing row to the database after true condition. The condition is if the database has values, then add the row but if is empty, don't add. 

I am a newbie in Alteryx and have not so much experience. Thank you for your help.

[grazitti_sapna]

Hi @Inactive User , You can read the data from database and then join it with your input data on the basis of columns which you want to check values for and then load the data to your target database.

[Inactive User]

@grazitti_sapna and how does it look like? Because I have no idea how I can do this. And unfortunately, I don't know if your solution will help me. It does not sound what I need 

[Christina_H · Accepted solution]

What about something like this?  It counts how many records are in the main data set, appends that to the extra row, then filters it out if the count is zero.

[gyang3]

@Inactive User it'd be helpful if you could provide a sample or snapshot of your input and what you're trying to accomplish.

[Inactive User]

Thank you @Christina_H. That solves my problem :)