Forum Discussion

JamesMcEwan's avatar
JamesMcEwan
Helper I
4 years ago
Solved

Pass through Record to Nested Table

I am looking to pass through the value of a record to a nested table within the same record, below is an example table where I am trying to pass through Name from the parent record into the nested ta...
Need Help
  • JamesMcEwan's avatar
    JamesMcEwan
    4 years ago

    Fount the Solution:

     

    let
    Source =    
        Table.FromRecords(
            {
                [CustomerID = 1, Name = "Bob", Order = 
                    Table.FromRecords(
                        {
                            [TransactionID = 1, LineID = 1],
                            [TransactionID = 2, LineID = 2],
                            [TransactionID = 3, LineID = 3],
                            [TransactionID = 4, LineID = 4]
                        }
                    )                
                ],
                [CustomerID = 2, Name = "Jim", Order =  
                    Table.FromRecords(
                        {
                            [TransactionID = 5, LineID = 1],
                            [TransactionID = 6, LineID = 2],
                            [TransactionID = 7, LineID = 3],
                            [TransactionID = 8, LineID = 4]
                        }
                    )
                ]
              
            }
        ),
    CustomTable = 
        Table.AddColumn(Source, "Custom", 
                each 
                    let 
                        ParentName = [Name],
                        AddName = 
                            Table.AddColumn([Order],"
                                Name",
                                    each 
                                        ParentName
                            )
                    in 
                        AddName
            )
in
     CustomTable
JamesMcEwan's avatar
JamesMcEwan
Helper I
4 years ago

Fount the Solution:

 

let
    Source =    
        Table.FromRecords(
            {
                [CustomerID = 1, Name = "Bob", Order = 
                    Table.FromRecords(
                        {
                            [TransactionID = 1, LineID = 1],
                            [TransactionID = 2, LineID = 2],
                            [TransactionID = 3, LineID = 3],
                            [TransactionID = 4, LineID = 4]
                        }
                    )                
                ],
                [CustomerID = 2, Name = "Jim", Order =  
                    Table.FromRecords(
                        {
                            [TransactionID = 5, LineID = 1],
                            [TransactionID = 6, LineID = 2],
                            [TransactionID = 7, LineID = 3],
                            [TransactionID = 8, LineID = 4]
                        }
                    )
                ]
              
            }
        ),
    CustomTable = 
        Table.AddColumn(Source, "Custom", 
                each 
                    let 
                        ParentName = [Name],
                        AddName = 
                            Table.AddColumn([Order],"
                                Name",
                                    each 
                                        ParentName
                            )
                    in 
                        AddName
            )
in
     CustomTable