Forum Discussion

ecalzavara's avatar
ecalzavara
Icon for Advocate II rankAdvocate II
5 years ago

How to find valid values based on multiple tables

Hi guys, I use this forum so much and I have almost found the answer I am after... Except for this one.   I have a table with: attributes name attributes values name of the valid-values refere...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

ecalzavara 

sry, not clear about your request. so your raw data only contains two columns? How you get the third column and forth column?

 

ecalzavara's avatar
ecalzavara
Icon for Advocate II rankAdvocate II
5 years ago

Nope,

My raw data (in the example provided) contains 4 columns (the formatting on the forum is not the best):


|   Attributes   |   Value   |   Data validation   |   Specific?  |

 

 

The Data validation column (and, if present, the Specific? one) defines the name of the table where the valid set of values are to be found for that specific attribute.

 

I hope this clarifies it.

Thanks

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    ecalzavara 

    what do you want now? check if value exists in the data validation table?

     

    Attributes Value Data validation Specific? Valid
    Num1 1 TableNum TN_C1 TRUE
    Num2 2 TableNum TN_C1

    TRUE
    Num3 3 TableNum TN_C1 TRUE
    Text1 4 TableTxt TT_C1 FALSE
    Text2 5 TableTxt TT_C1 FALSE
    Text3 a TableTxt TT_C1 TRUE
    Num4 b TableNum   FALSE
    Num5 8 TableNum   TRUE
    Text4 9 TableTxt   FALSE

     

    value 1 from TableNum, then true? value 9 not from TableTxt then FALSE?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      "value 1 from TableNum, then true? value 9 not from TableTxt then FALSE?"

       

      Correct