Tim

1. Community
2. Workbooks & Analytics
3. Extract all sublists with size n of list created by GROUPCONCAT

I solved it now by embedding a delimiter character (with CONCAT) in the list elements before GROUPCONCATing the elements. After that I can go for NGRAM and apply TOKENIZELIST on the resulting colum...

• View comment
• Tim
• June 24, 2016 08:42
• 0 votes

1. Community
2. Workbooks & Analytics
3. Extract all sublists with size n of list created by GROUPCONCAT

Hi Pablo, thanks for the suggestions, but the NGRAM function doesn't return a list but the elements of the input list concatenated. What I need is all subLISTS with size n so that I can process the...

• View comment
• Tim
• June 24, 2016 08:13
• 0 votes

1. Community
2. Workbooks & Analytics
3. Removing tuples with the same elements in lists

Thanks for the answer and for the suggestion Joel! In fact I have a sorting variable (date) and applied it now on the GROUPCONCAT function sorting the table beforehand by date. The problem remains....

• View comment
• Tim
• March 08, 2016 09:30
• 0 votes

1. Community
2. Workbooks & Analytics
3. Removing tuples with the same elements in lists

Thanks a lot Joel, now I have every path for 2 successive elements. Finally I want to merge them by their owner to get a full path per owner: owner 1: [a,a,a] -> [a] owner 2: [a,b,b,b,a] -> [a,b,a]...

• View comment
• Tim
• March 10, 2016 11:58
• Edited
• 0 votes