Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

check vaules

Hi Everyone,

I need Help,

 

I want to Create Calculate colmun in table 1 with name message  to show Text Message after check value in others table, based on below tables 

table 1
idmessage 
1in table 3
2in table 2
3in table 2
4in table 3
5in table 4
6in table 4
7in table 4

 

table 2
id 
2 
3 

  

table 3
id 
4 
5 
1 
table 4
id 
5 
6 
7 


Thnaks Advance 




Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Why is 5 in table 4, but not table 3? Is there any priority? You may try something like this, I think.. 

    = SWITCH( TRUE(), 
              COUNTROWS( FILTER( Table2, 
                                 Table2[id] = Table1[id])) > 0, "in table2", 
              COUNTROWS( FILTER( Table3, 
                                 Table3[id] = Table1[id])) > 0, "in table3", 
              ... 
              BLANK())

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Why is 5 in table 4, but not table 3? Is there any priority? You may try something like this, I think.. 

    = SWITCH( TRUE(), 
              COUNTROWS( FILTER( Table2, 
                                 Table2[id] = Table1[id])) > 0, "in table2", 
              COUNTROWS( FILTER( Table3, 
                                 Table3[id] = Table1[id])) > 0, "in table3", 
              ... 
              BLANK())
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thanks Anonymous  for  your replay,

       

      but when I write equality

      Table2[id] = Table1[id]

       the Table1[id] sentence show error or not defined, can you tell me about how  the  relation must be done between table1, table2, table3 and table 4

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        AlB  can you help me for  this  topic 

        thanks advance