Power Query , Transform Column of Records

[Dicken]

Hi, I have been trying to transform a column of records by another column ; I have mangaged this as an 'addcolumn' so;

Please Login or Register  to view this content.

But I cannot figure how to get to the 'outside' columns when using Table.TransformColumns,

Please Login or Register  to view this content.

I have attached a workbook showing working out so far, There is an addcolumn query using the above and a query called RecordTable
which is where I've got to using transform column; so the question really is to access , in this case the 'item' column when using
Table.TransformColuimns ?

Richard.

[romperstomper]

You aren't looping through the rows of the table, so there is no current row to get the Item from.

[Dicken]

So "I can't" is the short answer ? , thanks for taking the time to respond and I did learn a few new things while trying.

RD

[Dicken]

I know this is not quite the same but if in the I came up with, instead of adding the column and transforming you do in the so;

Please Login or Register  to view this content.

I have attached example

RD

[Dicken]

Another Work around is to add the value to be looked up to each record;
so zip together the list of records and the rec field value ;

Please Login or Register  to view this content.

and the add as a field, here all have same name;

Please Login or Register  to view this content.

last check if it is contained in each reocrd field list ;

Please Login or Register  to view this content.

I have attached workbook showing steps.

Richard.