Add a new row if condition is correct

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.

Join

Accepted answers

Christina_H

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.

All comments

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.

unknown

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

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.

unknown

Thank you @Christina_H. That solves my problem

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335