Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Lookup value from one table from another

I have a large table with one of the columns as 'CID' and there are multiple rows in this table with the same CID value. There is another table with distinct CID codes that I need to match the previ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous, sounds to me like you have selected "Add Measure" instead of "Add Column"?

    Just check that you have used "Add Column" and done so in the table that will hold the CID Flag.  In this case we are adding it to the CID Table.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Make the CID Flag a column in the other table, not the large table.  Thats the only way to reverse it correctly.  You will still be able to include it in your reports.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks..  Anonymous

 

However, it is not allowing me to keep the third arguement of lookuptable function to use a table column, but, only measures of either tables. And, I tried in both ways.. for the larger as well as the smaller table.

 

Is there something that I might be missing?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous, sounds to me like you have selected "Add Measure" instead of "Add Column"?

    Just check that you have used "Add Column" and done so in the table that will hold the CID Flag.  In this case we are adding it to the CID Table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous

     

    Thanks a lot Ross... It worked this time.. I guess I was trying to create a measure instead of a column. :P

    Really appreciate your help!