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.Tra...
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.

     

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