Add customn column

[ktt777]

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

[HotChilli · Accepted solution]

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