Forum Discussion

Zabeer's avatar
Zabeer
Helper I
4 years ago
Solved

Add custom column based on column id and field value

Hello,  I have a requirement to add a column that takes values from a field in another column. Example-   In other words, the new column should take the FieldValue of 'Vendor'  for each u...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Zabeer 

    You can add custom column in PQ as follows: Replace "Previous Step" with your last step in the query

    (x)=> Table.SelectRows(#"Previous Step", (y)=> y[ColumnID]  = x[ColumnID] and y[Field]  = "Vendor"  )[FieldValue]{0}

      

     

Zabeer's avatar
Zabeer
Helper I
4 years ago

Fowmy : Thanks for your reply. What parameters do I then need to invoke the function?

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Zabeer 

    You can click Column Column, paste the above code, click OK  then remove the word  "each" in the formula   bar