Add or Modify Rows

[Carolie_Delisle]

I’ve looked at all the add or modify rows and I still don’t understand.

I want to basically duplicate-ish an existing table with less columns and separate from the other one.
I need to keep existing data, in the table so I can first delete and clear the table.
So I’m trying to use the AddorModifyRows()
I want to check the OG table to the New table, for each row, If there is a match modify that row, and if no match then add row. Seems simple enough, but it keeps adding rows rather than modifying.
Obviously an expression issue, but I can’t seem to find a way to check the whole OG table, find the current value of New table, then validate if there’s a change and modify or ignore.
and if there’s a row in OG table not present in new table then add it to new table.

I’ve tried so many things I lost track, any fresh perspective?
Thanks !

[Piet_Strydom]

@Carolie_Delisle

I want to basically duplicate-ish an existing table

Let’s take a step back - have you considered creating a view of that table? That would be a much easier solution.
P

[Carolie_Delisle]

@Piet_Strydom

ed creating a view of that table

Yes, I know, but I need it to then contain past information that will be deleted through an archival process.

I need the modifications of the OG table to appear in the new table, but not vice-versa. And the new table will have column type and format modifications so, that would affect the OG table if it was a view.

Current attempt at filtering and I can’t seem to select a variable “set value” based on current value.

[Carolie_Delisle]

Latest,

It’s now only adding one row but it’s the whole OG table dump in a single row.