I have two tables, Table A and Table B below (Sample)
Table A
UniqueID
Col A
Col B
ABC111
ABC
111
DEF222
DEF
222
GHI333
GHI
333
JKL444
JKL
444
MNO555
MNO
555
PQR666
PQR
666
STU777
STU
777
WVX888
WVX
888
Table B
UniqueID
Col A
Col B
ABC111
ABC
111
DEF222
DEF
222
GHI333
GHI
333
JKL444
JKL
444
What I am trying to do is remove all the rows from Table A (Based on UniqueID) that have same value in Table B(Based on UniqueID).
I have a solution in hand but its nested loops and I want to avoid that as there are more than 16K rows in both the table.
Thanks for the attached workflow, it kinda resolved all my issues with the problem. Got to learn something new. Just wanted to know one thig, the query used, is that a dot net query?
@Devbrath_Rajkhua
LINQ is a query language that can be used within the .Net framework. It help us much to do things in a shorter way. For more information on this topic have a look here: