Hi, I have been trying to transform a column of records by another column ; I have mangaged this as an 'addcolumn' so;
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 RecordTablePlease Login or Register to view this content.
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.
Bookmarks