Update to Table

Question

I have a requirement a like this.

1) Get Account Record with the status ="New" I used input tools for this.

2) Update imported data with the status ="Pending"

With the Post Create SQL I am able to update.

But I need a update it with out using this Post Create.

Cant it be done by simply using Update query inside any tool?

Any idea?

Thanks,

Krishna

Aguisande · Accepted Answer

Hi @Krish

Maybe you can explore the Update: Insert if New method in the Output Tool to get this.

Only need is to have your primary keys properly in the table.

Best,

_AG_