Delete Data from Target Table when Flag sets

[Former Member]

Hi All,

I am creating BODS job. here I am going to use TABLE COMPARISON and HISTORY PRESERVING.

My problem is I want to remove older records from Target Table only if Value from one column reach to particular Value or Value get change. And also insert new Records if exist.

Can any one help?

[akhileshkiran]

Hi

Can you elaborate the requirement and explain with a scenario. So that we can help you out to provide the solution.

i think you can create a script by using sql function on the target table.

Regards,

Akhilesh Kiran.