Join Issue

[Cognos_Jan2017]

Running 10.2.2 from Vendor Cloud App.

Their Framework Manager (I have no control over that) design includes these two Datatypes ...
1 - National Language Variable Length Character -- from a concatenation

2 - Character Length 16 -- from an If Else If ...

Both look like Text Datatypes (from my VB background).

Is there a way to get these two different Datatypes to "Match" so a Join will work?

TIA, Bob

[dougp]

Since you don't have control over the FM model... Are you creating two queries and trying to join them?

Be careful.  If they are not joined in the model, that may be deliberate.  You may get wrong results.

Yes, you can join them in a report.  Cast them to a common data type in the source queries.

[Cognos_Jan2017]

Thank you dougp.

Yes, Cast makes sense,I cast the 2 Fields in question to varchar(50), added a new Join Query,  and let the Author know.

My Laptop, for some reason, does NOT open a "Join" Icon so I am relying on the Author to
attempt the Link of the two varchar(50) Fields.

I will report back here when the Author lets me know if it worked.  It should.

[Cognos_Jan2017]

My apology for the delay in following this up.

The User said the Cast of the two Fields to varchar(50) did not work.

Further thoughts welcomed.

TIA, Bob

[dougp]

What is the error message the report is producing?

My Laptop, for some reason, does NOT open a "Join" Icon

What OS and browser are you using?