Forum Discussion
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...
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.
Also, it seem the third argument needs to be a single value so, when I try using a column of another table, its just showing me the option to choose another measure as the third argument.
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.