Create a column by comparing two data sets

[rstanleyraj]

Hi,

I have to compare two different tables and create a column. Following is the sample input and output.

Input

Table 1

Product

A

B

A

E

S

A

Table 2

List

A

B

C

D

Output

Product	Status
A	Available
B	Available
A	Available
E	NA
S	NA
A	Available

Could anyone please guide me how to achieve this.

Any help is greatly appreciated!

Thanks,

Stanley

[BhaveshPatel · Accepted solution]

STEP 1 CREATE A RELATIONSHIP BETWEEN TWO TABLESSTEP 2 CREATE A CALCULATED COLUMN WITH IF AND RELATED AS SHOWN ABOVE.

[Greg_Deckler · Accepted solution]

Perhaps a measure in Table 1 like:

Status = IF(COUNTROWS(RELATEDTABLE(List))>0,"Available","NA")

[BhaveshPatel · Accepted solution]

STEP 1 CREATE A RELATIONSHIP BETWEEN TWO TABLESSTEP 2 CREATE A CALCULATED COLUMN WITH IF AND RELATED AS SHOWN ABOVE.

[rstanleyraj]

Thank you very much for the inputs. It worked.