Forum Discussion
Manipulating Nested Table with Function
So I finally solved my issue. After further reviewing (i.e. watching YouTube videos) that covered 'each' and '_' in more detail, to ensure I understood how that all worked, I discovered I was doing everything correctly. The problem was I didn't realize/forgot that in my function I had a drill down on the Field with the table, so in effect I was attempting to drill down twice, which explains the error. I disovered my mistake quite by accident after I was toying further with the code and making duplicates.
As they say, if you're trouble-shooting yourself, you're just workin'. 🙂
In your example data, you should use [ColumnOfTables] as the table reference in your function. That is the field that hold the table on that row. Also, why is a custom function needed vs. a simple custom columne with an expression like
let
filtervalue = [DataType]
in
Table.SelectRows([ColumnOfTables], each [ColumnToFilter] = filtervalue)
What transformations is your function doing?
Pat
Pat