Page 1 of 1

Need help to cleanup table

Posted: Tue Oct 04, 2022 8:41 am
by Yarobi
Hello all,

I made a mistake and need to cleanup a table.

After run 120 I noticed my wrong join and now I need to clean duplicated data.
But I can't figure out how to do this.

Anyone who can help me a little?

In attachment I took a screenshot from my sampledata.
So I only need to keep the green lines, every time the 'UREN' changed.

Re: Need help to cleanup table

Posted: Mon Nov 21, 2022 4:10 pm
by ray.wurlod
In Job1 process the data and detect changes in UREN, only outputting on change.
Job 2 loads the results of Job1 into your table, probably truncating it first.