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
Solved! Go to 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_