Customer Portal

How do I sort groups of child columns within a parent row

Comments 4

  • Avatar
    imriskal
    0
    Comment actions Permalink
    Hi, eneric,

    Can you please rephrase your question? I am not exactly sure what is your goal right now. This is how I understand it:

    The first column (The one with letters "A") has to be unchanged. The other columns have to be sorted so that all numbers in a row will be sorted in ascending order. But it would imply that for any row, data in it have to be sorted independently and not by the whole columns.

    Am I right? And is the number of columns set somehow or you do not know it before the graph run start?

    I also do not understand how the numbers move between lines in your example. How is it possible that "2" moved up next to "6"? Is it coincidence that numbers are sorted within rows and also within columns? Which rules apply for this moving?

    Thank you in advance.

    Best regards,
  • Avatar
    eneric
    0
    Comment actions Permalink
    Sorry for not being clear! I've expanded the example and attached a screenshot to help illustrate.

    The basic structure is preparing for a conversion to xml, so you can think of nesting/sorting the parent elements and the related child elements.

    Basically the AAAAA rows need to be sorted and eventually look like the BBBBB rows.

    The sort is first by column A (cluster the unique EEIDs), then column B (to sort by date and bring the parent row data to the top), then column D (sort all group 1 elements together and sort blank rows to the bottom), then column F (sort all group 2 elements together and sort blank rows to the bottom).

    But each new sort must only be within that group and not change the EEID/Parent record sort, or any of the previous group sorts.

    Does this clarify the situation at all?


    Thanks!
  • Avatar
    imriskal
    0
    Comment actions Permalink
    Hello, eneric,

    No problem, I think I understand now. Please, take a look on this example graph, it should meet your requests.

    Best regards,
  • Avatar
    eneric
    0
    Comment actions Permalink
    You're the best!

    Thank you!!!

Please sign in to leave a comment.