Update to Table

[Krish]

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 solution]

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_