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 id messag...
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())
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 

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous 

    Anonymous 's solution looks good to me. Are you sure you are entering it correctly? If you're getting an error that something is undefined, do check the names of the tables are the correct ones: 'table 2' vs 'table2' etc.

    Cheers