topic Re: Updating a table in Data Quality

Updating a table

RMotta2408 — Fri, 15 Nov 2024 23:02:29 GMT

Hi guys,

Is it possible to update certain records in a table, based on some conditions, and create a list of records that were changed?

If so, is it possible to have a column with the old value and another column with the new value?

Thanks so much,

Rui

Re: Updating a table

Anonymous — Thu, 07 Apr 2022 23:01:45 GMT

You can do this with a tMap. Your main input should be your new (or updated) data. Then you will need a lookup from the table you are updating. Join in the tMap and identify the rows that need to be updated. Then have 2 outputs; the first to update your table, the second to output the old and new values (along with any key data you may require).

Re: Updating a table

RMotta2408 — Fri, 08 Apr 2022 07:01:34 GMT

Hi @Richard Hall ,

Thank you so much for the answer.

Re: Updating a table

RMotta2408 — Fri, 08 Apr 2022 10:06:24 GMT

I have another follow-up question.

You say that my main input should be my new or updated data. I was updating the table using an SQL command (using the tDBRow component).

My question is this: in my case, what should my main input?

Thank you.

Re: Updating a table

Anonymous — Tue, 12 Apr 2022 20:38:43 GMT

Sorry for the late response here. I would use your query to return your data using a tDBInput.

Re: Updating a table

RMotta2408 — Wed, 13 Apr 2022 09:21:36 GMT

Thank you so much. I appreciate it.

Rui