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
spinfuzer's avatar
spinfuzer
Solution Sage
2 years ago

see latest post

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