Hi,
I have attached a sample sheet which contains the sample data along with the output. I have two files which are source(Source Table and CODE Table) and one output (Output Table).
The requirement is that if any of the Code present in Source Table matches with the CODE Table then I need that record in the output.
One way of achieving is is to Unpivot the Source Table and then do the lookup and filter out and dedupe but that would hamper my performance as there are 300 million rows and I have 25 CODE columns in my actual Source Table so the data wold explode if I unpivot.
Is there any better way of achieving this other than what I am thinking of above.
