Hi.....
Dunno if anyone can help......
I have two datasets
Dataset 1 has columns 'policyid' and 'code'
Dataset 2 has two colums 'code' and 'valid'(Y/N)
Is there a way that I can delete rows from Dataset 1 (or create a third Dataset) if the code in the row is 'invalid' in Dataset 2?
Any hints gratefully received!!
Paul