Passing parameters among nested functions- Record, Fields and tables

[PODL]

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.

[lbendlin · Accepted solution]

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]

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")
          }
        )
    )
  )