Append Rows if new Column Values Else Replace

[harshal98]

Want to Replace existing value for position  if id, date and number are same values existing in table.

If any of the 3 are new values append the row. 

Input 2 Files

Output File : 

Output File

[atcodedog05]

Hi @harshal98 

You can use a Union Tool to merge and Sample Tool Last 1 row groupby Id to get the desired output.

Hope this helps 🙂

[atcodedog05]

Hi @harshal98 

Something like this.

Here is a workflow for the task.

Workflow:

Last 1 in configured to get the latest data.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[RishiK]

@harshal98 check out this quick workflow.

[grazitti_sapna]

Hi @harshal98 , you can do this using join tool as well.

I hope this helps.

Thanks.