|
Post by account_disabled on Dec 7, 2023 11:35:02 GMT 2
Count function you can count how many occurrences there were in a given text how many times a space appeared one item in the list corresponds to one space and one space to one word counting the number of list elements you can specify the number of words. This operation can be embedded in the append new column function which will cause it to be repeated for each record. The result will be the original text line and word count. Table. each List. Occurrence To be sure you can change the type of the newly added column to numeric using the Table function. Table type number In this case however only the largest value among all is important so you should sort the data by the number of words descending using the T able. Sort function Email Marketing List Table. . Then remove the text column and leave only the word count column. To do this you need to use the function Now just select the first record from above that will correspond to the most words in the line. For this purpose the function is used which only accepts the data source and the number of top records to download. However the previous operation returned the result as a list value so to get the final answer you must select the first element of the list using the List. First function. List. First Having knowledge about the maximum number of words in lines you can use the Splitter. SplitTextByDelimiter function to split by specifying the split character as a space character and the number of columns as a previously calculated value. an array was returned containing several dozen columns with single words. To flatten this data into a single column you can use the Table. Unpivot function. However it requires specifying the name of the columns that are to be flattened.
|
|