Common/Uncommon data in Two or more tables

[#1]

Hi All,

We have an issue here.

We are trying to find out the common and uncommon data from two fields from two separate tables and then we are trying to add another filed (Flag) to the table which has the maximum values, which will have a value YES if data matches and NO if the data is not matching.

Please find the data as pasted below.

Table1	Table2
Col1	Col2
A	A
B	B
C	X
D	E
E	D
F	U
	R
	S
	T

Result
Col2	New column
A	Yes
B	Yes
X	No
E	Yes
D	Yes
U	No
R	No
S	No
T	No

Thanks in advance

[tresesco]

Try like:

Load

          Col1,

          Col2,

          If(Col1=Col2, 'Yes', 'No') as NewCol

[#3]

Thanks for your help but Col1 and Col2 are fields of two different tables and those keys are primary foreign keys. I have linked those tables with the help of these columns... Please give me solutions for this

[tresesco]

Could you share a sample app?

[sushil353]

Try the below code:

Table1:

LOAD * Inline

[

Col1

A

B

X

E

D

U

];

Table2:

LOAD Col1 as Col2,if(Exists(Col1),'Yes','No') as flag Inline

[

Col1

A

B

X

E

D

U

R

S

T

];

Its output is:

A	Yes
B	Yes
D	Yes
E	Yes
R	No
S	No
T	No
U	Yes
X	Yes

HTH

Sushil

[Jason_Michaelides · Accepted solution]

Hi,

You can use ApplyMap() for this:

Map_TableA:

MAPPING LOAD

  Col1,

  'Yes'

From...Table1;

Table2:

LOAD

   Col2,

   ApplyMap('Map_Table1',Col2,'No') AS [New Column]

From....Table2;

Hope this helps,

Jason

[#7]

Thank you guys !!!