Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
5 years ago
Solved

Add customn column

hi ,

 

i want to add a new column with the value equal to a sepecific cell in the file.

For example, all the value in the new column is equal to row 5 of Data.Column3 

How can i do that? 

thanks alot

 

 

 

Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    You can refer to items in a list with curly brackets so something like this in the 'add new column' :

    #"Added Custom"[Column1]{7}

    So it's     previous_step   column_name   list_index

     

    Indexes are 0-based so the above returns the 8th item

     

1 Reply

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    5 years ago

    You can refer to items in a list with curly brackets so something like this in the 'add new column' :

    #"Added Custom"[Column1]{7}

    So it's     previous_step   column_name   list_index

     

    Indexes are 0-based so the above returns the 8th item