Forum Discussion
Solved
Create a list from another table to feed a custom function
Hi all, I have a custom fuction that counts the times words on a list are found in a string: let
CountKeywords = (title as text, keywords as list) as number =>
let
...
Keywords= Table.Column([Table],"Product")
[Table] - This refers to a cell
Table - This refers to entire table
Use like this
Table[Product]
OR
Table.Column(Table, "Product") ### This was my mistake to put Table as [Table]
Thank you.
I tried Table.Column same error mesagge. Here is the sequence of my code:
// Source and some cleaning...
#"Filtered Rows1" = Table.SelectRows(#"Changed Type", each ([Source.Name] <> "xxx.xlsx")),
//Keywords = {"One","Two","Three"}
Keywords= Table.Column([Table],"Product"),
AddedFound = Table.AddColumn(#"Filtered Rows1", "found", each Busca_cuantos([title], Keywords)),
//Some conversions.....
Hope this helps to find the problem.
Regards
Keywords= Table.Column([Table],"Product")
[Table] - This refers to a cell
Table - This refers to entire table
Use like this
Table[Product]
OR
Table.Column(Table, "Product") ### This was my mistake to put Table as [Table]