LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Populate columns with variable data

    Employee
    Posted 07-24-2014 23:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: RuthK

    Hi all,

    Hoping someone can help please - I'm a bit of a noob...

    I have several tables that I have joined using Case ID as the key. The main data source is one record per Case ID. I am now adding a table where I have multiple records per Case ID. The second table also has a 173 possible menu items and there is no set pattern for the variables to be allocated to a Case ID. The only certainty is that there is at least 1 record per case - but there can be as many as 15 records from the second table per Case.

    The second table is made up of menu data where a customer's requirements are gathered and at the closure of the case, each requirement is marked as being Met or Not Met. Each requirement can only be Met or Not Met.

    I've cleansed that data and have eliminated any cases where there are more than 5 variables. Now I need to be able to create a filter or some such to calculate and add the corresponding number of columns to the main data table. I need for each Case; if there is value 1, populate column 1 and 1a, if there is value2, populate column 2 and 2a etc etc. eg: Req1, Met1, Req2, Met2, Req3, Met 3 etc


    Any ideas... please....

    Cheers,
    Ruth


  • 2.  RE: Populate columns with variable data

    Employee
    Posted 07-25-2014 09:25

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    The attached graph demonstrates one of the techniques to solve this.

    If you think of an excel pivot table, the LAE Names to Data node accomplishes a good bit of the same function, with three exceptions:
    1) Any aggregation of data (sums) must be done before using NamesToData
    2) If you need to process multiple columns (Met, Requirement) then you have to use NamesToData twice, once for each column, and combine the results as I've done here.
    3) The resulting column order is likely not what you would desire, but that can be solved with the technique in another recent forum thread.
    Attachments:
    MergingCases.brg


  • 3.  RE: Populate columns with variable data

    Employee
    Posted 07-28-2014 23:43

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: RuthK

    Thanks stonysmith - that did exactly what I needed it to! Cheers