Posts by _disha_

  • PLEASE HELP ME OUT Parent-Child hierarchy construction

    Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Hi,


    There is a DAX path() function available in excel 2013 ,as mentioned in the below link:
    http://office.microsoft.com/en…s-in-dax-HA102839072.aspx
    If you refer the PATH column , i need my output like this.


    I installed Office 2013 trial version and strangely found that I cannot use this function.And there is no useful link of detailed explanation of using this function.
    If there is any link where-in in VBA it is available as my expected output is ,please guide me. thanks ..

  • PLEASE HELP ME OUT Parent-Child hierarchy construction

    Hi,
    I am new to VB, saw ur post on providing parent child hierarchy in visually structured way in excel. Hoping that you will help me out in this issue . Please mail me in



    [email protected]



    There is a table in xl as below:
    Calling Called
    Folder1 Sub1
    Folder1 Sub2
    Sub1 Sub3
    Sub3 Sub4
    Folder2 Sub6
    Folder2 Sub7
    Sub7 Sub8
    Sub7 Sub9



    Explaination of the table:
    "Folder1" is calling child "Sub1" and "Sub1" is calling "Sub3", and likewise ...



    I need an output in an hierarchy saying parent->child->subchild...



    Expected Output 1:
    Folder1->Sub1->Sub3->Sub4
    Folder1->Sub2
    Folder2->Sub6
    Folder2->Sub7->Sub8
    Folder2->Sub7->Sub9



    Expected Output 2:
    In the 3rd column of excel against each row of Calling & Called columns ,Output should be as below(i.e, Parent|Child|...):
    Folder1|Sub1
    Folder1|Sub2
    Folder1|Sub1|Sub3
    Folder1|Sub1|Sub3|Sub4
    Folder2|Sub6
    Folder2|Sub7
    Folder2|Sub7|Sub8
    Folder2|Sub7|Sub9



    Please help me out in this. Thanks