Forum Discussion
MP_123
Microsoft Employee
Microsoft EmployeeIterate over each cell in a table
hi, i want to iterate on each cell in the column (don't know how many rows and column will be, but it's not complicated to get) i want to call a function from each cell, how can i do it? also poss...
Hi MP_123,
Perhaps you can try to write a function to check the table columns which contain the specified delimiter.
For example:
let ContainColumn= (sourcetable as table, delimiter as text) => let ColumnName= Table.ColumnNames(sourcetable), result= List.Transform(ColumnName, each if List.Count(List.Select(Table.Column(sourcetable , _ ),each try Text.Contains(_ ,delimiter) otherwise null))>0 then _ else null), RemoveNull=List.RemoveNulls(result) in RemoveNull in ContainColumnInvoke:
Regards,
Xiaoxin Sheng
MP_123Microsoft Employee
Microsoft Employeehi, thank you Anonymous!!
i want to iterate on each cell and to split the cell by delimiter (i don't know the columns i want to split in advance)
can you please help me? i'm a bit complicated with the splitter function
thank you very much
Hi MP_123,
Perhaps you can try to write a function to check the table columns which contain the specified delimiter.
For example:
let
ContainColumn= (sourcetable as table, delimiter as text) =>
let
ColumnName= Table.ColumnNames(sourcetable),
result= List.Transform(ColumnName, each if List.Count(List.Select(Table.Column(sourcetable , _ ),each try Text.Contains(_ ,delimiter) otherwise null))>0 then _ else null),
RemoveNull=List.RemoveNulls(result)
in
RemoveNull
in
ContainColumn
Invoke:
Regards,
Xiaoxin Sheng