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.
Need help to cleanup table
Moderators: chulett, rschirm, roy
Need help to cleanup table
- Attachments
-
- Cleanup table.jpg (117.62 KiB) Viewed 2402 times
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Need help to cleanup table
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.
Job 2 loads the results of Job1 into your table, probably truncating it first.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.