Forum Discussion
TRUE/FALSE from another table
Hi,
I have two tables in tabular model
Table1 has multiple records with details
Table 2 has distinct records with Status column (TRUE/FALSE)
How should I bring in this column to Table1
I tried RELATED on Table1 to bring this coulmn in from Table2, but it shows some rows as BLANK because they're not DISTINCT
What is the BEST way to bring in a TRUE/FALSE column from DISTINCT rows table into a multiple records table
SAMPLE
Table1
| Student_No | Subject | Score |
| 1 | Math | 90 |
| 1 | Science | 95 |
| 2 | Math | 85 |
| 2 | Science | 85 |
Table2
| Student_No | Status |
| 1 | TRUE |
| 2 | FALSE |
End result should be
| Student_No | Subject | Score | Status |
| 1 | Math | 90 | TRUE |
| 1 | Science | 95 | TRUE |
| 2 | Math | 85 | FALSE |
| 2 | Science | 85 | FALSE |
Thanks
6 Replies
What formula do you use?
I used the same formula, but I see blanks for records which are duplicates
Okay so how are the two tables related? Are you saying you are getting only one Status per Student_No in Table 1?
