Forum Discussion

DiKi-I's avatar
DiKi-I
Post Partisan
2 years ago

Power query help

Hi , I have multiple relationship table around 5 to 6 which are available in mutiple tables. I'm attaching some sample data there are 3 tables table1, table2, table3. Realtionship is from parent...
Need Help
DiKi-I's avatar
DiKi-I
Post Partisan
2 years ago

 I tried with only two tables initially but its not loading and taking forever.
There is no circular dependency (A->B)
There are around 2k records 

spinfuzer's avatar
spinfuzer
Solution Sage
2 years ago

Are you sure you are referring to the right columns in the join and not inadvertantly going from A --> A --> A--> A in an infinite loop instead of A --> B?

 

I added 500 random records and it ran just fine.  Do you have a larger data sample?

 

  • DiKi-I's avatar
    DiKi-I
    Post Partisan
    2 years ago

    Hi 
    I checked the data the classname is different but in some cases the parent and child will be same.
    For those entries I am getting many rows.
    Hierarachy can be same for some records.



    • spinfuzer's avatar
      spinfuzer
      Solution Sage
      2 years ago

      Are you saying you have something like

      Parent = AA, Parent Class Name = Business Service

      Child = BB, Parent Class Name = Business Service

       

      What is your expected result there?

    • spinfuzer's avatar
      spinfuzer
      Solution Sage
      2 years ago

      see latest reply

      • DiKi-I's avatar
        DiKi-I
        Post Partisan
        2 years ago

        Hi,

        I tested the above and now I am getting the result quickly but if the values are same I am getting null in the child only getting the value in the first parent.
        values are below in my data
        business service= A

        business service line =A

        department = A
        and I final result I am getting from you m query is: 

        business service= A

        business service line =null

        department = null

         

         

        my data is like this