Power Query Records access record filed in let statement,

Hi,
I have what I wanted as far as result but I think it may be better written,

So within a let statement I wanted to get the record field values if TRUE so below produces true / false column

Please Login or Register  to view this content.

This below gives me true and false that I want, but it means typing it all out each time I want to use it in a step

Please Login or Register  to view this content.

Since original post I have got a result but if any one can suggest a neater / shorter way of wriing it plase let me know, I would like to use the 'one , two, three, four ' form the original records, but not sure this is possible. I will attach copy;

This code i have is ;

Please Login or Register  to view this content.

Richard.

You could do it like this

PHP Code: 

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    yList = {{"A".."D"},{"One","Two","Three","Four"},{10,20,30,40}},
    result = Table.AddColumn(Source,"Custom", each Record.FromList(List.Transform(yList{0}, (x)=> if x = [Item] then yList{2}{List.PositionOf(yList{0},x)} else not true ),yList{1}))
in
    result