Forum Discussion
Solved
Create a column by comparing two data sets
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 ...
STEP 1 CREATE A RELATIONSHIP BETWEEN TWO TABLESSTEP 2 CREATE A CALCULATED COLUMN WITH IF AND RELATED AS SHOWN ABOVE.
Perhaps a measure in Table 1 like:
Status = IF(COUNTROWS(RELATEDTABLE(List))>0,"Available","NA")
STEP 1 CREATE A RELATIONSHIP BETWEEN TWO TABLESSTEP 2 CREATE A CALCULATED COLUMN WITH IF AND RELATED AS SHOWN ABOVE.
Thank you very much for the inputs. It worked.