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

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
        Community 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      hi ,

      There is no need to add relationships. Please check the names as AIB suggested.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        thanks Anonymous , AlB 

        I Not use names that mention it   here, I use the table  just to explain the case
        you can see below image to more details, maybe after = sign must be an expression or a column name.