do not know what operation to use.

I have two dataset as shown in attached file. Dataset1 and Dataset2.

Do some operation between thos two to get Dataset3.

so dataset3 is combination of pink rows from Dataset1 and purple rows from dataset2 as in both doble line bordered area is the same and see how green rows disappers.

Answer 1

[ES]

To me it appears like union of two tables. see here . Also I dont understand why dataset2 takes precedance over dataset1 when a data is present in both the datasets. If there is some logic/reason behind that, then you can proceed to use union.

[Neesha]

please check it is not intersect of both. It is more like setdiff(dataset1, dataset2) and then concatenating set2 but for somereason it is not working.

Dataset2 is data with regular cloth and that needs to take precendence over wedding cloths...that is all

intersect will give me what exist in both,

[ES]

I was meaning union. Edited now. You seem to be on the right path with setdiff. What error do you get?

[Neesha]

I do not get an error if I do not use 'rows' (for some reason 'rows' never worked for me) but my resultant dataset is the same as Dataset1

union will have dats from both , that is not the goal .

If i can get setdiff(dataset1, dataset2 ) = rows in pink highlight. I can do rest