Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

left join

Hi All,

I have big issue with Merging Queries function (power query ).

 

I have 2 tables:
1.Table A => Fact table

2.Table B => Duplicate from Fact table

 

I join by left outer join from Table B  into Table A. (Table A is the left table)

as you can see in table B the numbers sort from A-Z

however , After merge to Table A their is mess with the numbers.

In the bottom line I want to join Table C to A 

 

 

Links attached -

 https://app.powerbi.com/groups/b8d70bb1-560b-4902-9f7c-3a6b339aab9e/reports/cd6cd7bd-3048-420f-8332-126eaca6352c?ctid=26545433-51b7-4511-80f5-afb057ad548f

 

Hope for your responds

 

Dan

 

 

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    In the first line it is sorting alpahbetically, in the second it is sorting numerically. My guess is that there has been a type change that was automatically done that changed the column from a text column to a number. This should appear as a change type step in the query editor.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      in query editor i have onle

      #"Merged Queries1"

      #"Expanded ..."

       

      I haven't as a change type step

       

      Dan

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        The other possibility is that in the first line you have a different column name to the second, are both these columns the same data type?

         

        How are these columns constructed?