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
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.

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

Hi SDream7,

I think you are using same name "Client ID" in both tables. For NATURALLEFTOUTERJOIN to work properly, the "Client ID" field name should be different in both tables TableA & TableB. 

Could you please share the screenshot of DAX expression you used for getting TableC?

 

Thanks,

Rahul