Forum Discussion

SDream7's avatar
SDream7
Icon for Helper I rankHelper I
8 years ago

Merging queries based on multiple conditions

Hello, I'm having difficultly merging two tables through the merge query function. Here's my situation: Table A has numerous fields, but the ones of interest are [First Name], [Last Name], [C...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

RahulYadav

As per your point#3, you have said not to add any joins between tables.

However, I get below error -

 

 

 

 

 

 

 

 

 

Any idea?

RahulYadav's avatar
RahulYadav
Icon for Resolver II rankResolver II
8 years ago

Hi SDream7,

Sorry for the confusion.

I have added join based on ClientID field.

 

Thanks,

Rahul

  • SDream7's avatar
    SDream7
    Icon for Helper I rankHelper I
    8 years ago

    I got the same issue as the user above:

     

    "No common join columns detected. The join function 'NATURALLEFTOUTERJOIN' requires at-least one common join column."

     

    How would I fix this?  What do you mean you added join based on Client ID?

     

    Sorry, i'm new to BI :(

    • RahulYadav's avatar
      RahulYadav
      Icon for Resolver II rankResolver II
      8 years ago

      Hi SDream7,

      Create a new join between TableA & TableB as below through Manage Relationship.

       

       

      Let me know if you get the desired result.

       

      Thanks,

      Rahul

      • SDream7's avatar
        SDream7
        Icon for Helper I rankHelper I
        8 years ago

        When I link both fields into a relationship, I can only link it as a Many to One.

         

        Then the error I get on Table C is "The Column with the name of 'Client ID' Already Exists in Table C.