Forum Discussion

PODL's avatar
PODL
New Member
2 years ago
Solved

Passing parameters among nested functions- Record, Fields and tables

Hi,

I'm trying to add a column (Hubrid Value) to a nested table, while using Record.Transformfields on the nesting table.

This is what I've been trying to do:

 

 

X= Table.FromRecords(Table.Transformrows(IDandKvutsa, (r)=>
Record.TransformFields(r, {"CSV Table With ID and Kvutsa", (TableField)=>
Table.AddColumn(TableField,{"Hybrid Value", "try"})

})))

 

 

My nested tables are in "CSV Table With ID and Kvutsa" column.

I get the error "2 arguments were passed to a function which expects between 3 and 4".

My logic says I can pass on the field of the record "r" I've just passed, but surely I'm missing something.

 

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    use PowerQueryFormatter to bring your code into an easier to read format

     

    X
  = Table.FromRecords(
    Table.Transformrows(
      IDandKvutsa, 
      (r) =>
        Record.TransformFields(
          r, 
          {
            "CSV Table With ID and Kvutsa", 
            (TableField) => Table.AddColumn(TableField, {"Hybrid Value", "try"})
          }
        )
    )
  )

    Then provide some more details on IDandKvutsa , TableField,  and generally what you are trying to accomplish as it is not clear from the code.

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    use PowerQueryFormatter to bring your code into an easier to read format

     

    X
  = Table.FromRecords(
    Table.Transformrows(
      IDandKvutsa, 
      (r) =>
        Record.TransformFields(
          r, 
          {
            "CSV Table With ID and Kvutsa", 
            (TableField) => Table.AddColumn(TableField, {"Hybrid Value", "try"})
          }
        )
    )
  )

    Then provide some more details on IDandKvutsa , TableField,  and generally what you are trying to accomplish as it is not clear from the code.

     

    • PODL's avatar
      PODL
      New Member
      1 year ago

      IDandKvutsa- Is a table

      TableField- Is just a parameter. It represents the nested table in each row of IDandKvutsa

       

      I figured it out, my mistake was the list I passed in the AddColumn function. This is how it should look like:

      X
  = Table.FromRecords(
    Table.Transformrows(
      IDandKvutsa, 
      (r) =>
        Record.TransformFields(
          r, 
          {
            "CSV Table With ID and Kvutsa", 
            (TableField) => Table.AddColumn(TableField, "Hybrid Value", "try")
          }
        )
    )
  )