Lookup data in another table

[Former Member]

Let's say I have a 2 dimensions that are numeric. To get the text value for each numeric value I have join with another table.

What do I do to get those values in the report?

[Former Member]

Can someone let me know if this is the right approach? I added a dimension variable with the following formula:

=[Fname] + " " + [Name] ForEach([Sent To]) In Report

That only works on the ones that have distinct [Sent To] values. On the ones that don't I get #MULTIVALUE

What am I doing wrong?

[Former Member]

HI Kyle,

can you ellaborate a little more?

CHeers,

Rogerio

[Former Member]

I have added before and after pics of when I put in the formula.

[Former Member]

Hi, try to create another query that brings the code and the name. Merge both queries on Code, create a detail variable detnam with associated dimension the merged code and with value equal the name. Now you can drop det name onto your report.

Cheers,

Rogerio

[Former Member]

I got an error.

This is what I did:

created another query that brings the code and the name.

Merge both queries on id

Now I think I did this:

create a detail variable detnam with associated dimension the merged code and with value equal the name.

[Former Member]

I read somewhere where the #datasync error is caused by not merging the two data providers ( i guess queries) but i did.

[Former Member]

#DATASYNC means that some dimension is not merged. How many queries do you have ? Which object comes from which query. I´ll post a screen shot of what I mean by creating a detail variable.

Try concatenating FNAME and NAME , like [full name]= [FNAME]+[NAME] and create a detail variable on [full name].