Lookup value A table of multiple values was supplied where a single value was expected.

[deep01]

Hello All

I am using lookupvalue function to get one column named as category from table 1 into destination table 2.

I got an error "

 A table of multiple values was supplied where a single value was expected"

When I checked table 1, I found both the columns which is market and category has dupilcate values and  lookup function won't work with duplicate values , it should be unique.

But I cannot make them unique as my category has divided into 3 sections i.e; category 1,2,& 3 and it is the only reason it has duplicate entries in the column.

 

Table 1 contains only two columns, market and category. Even market column has duplicate values based on location.

But still I need category column in my table 2.

Can anyone suggest me alternate to approach to achieve this?

It's an urgent help ..

[lbendlin]

Create a temporary table (with VALUES() or DISTINCT()) and then do your lookup against that one.

Or limit your return value to TOPN(1)