Count number of elements in each column cell (Delimiters) and display the values in the new column?
Hi, Having a column like below, Data: "[""bTravel"",""bTravel Planning"",""travel booking"",""travel planning""]" [] "[""engine"",""news"",""search""]" [] "[""collaboration"",""connect"",""connections"",""network""]" To get the count of the words in each cell using a delimiter comma(,). Used fx as below for the specific count of keywords, New Column name is keywords count. = Table.AddColumn(applicationcatalog_Table, "keywords count", each List.NonNullCount(Text.Split([keywords],","))) Result: Why its displaying resuit as 1 in cell, instead of 0 as result for [] in the coulun(keywords count) cells.? Thank you.
