Tim
- Total activity 8
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 2
Activity overview
Latest activity by Tim-
Tim commented,
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...
-
Tim commented,
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...
-
Tim created a post,
Extract all sublists with size n of list created by GROUPCONCAT
Hello, if I have session data for example (time with t0 < t1 < t2 ... < t8): userX | a | t0 userX | b | t1 userX | c | t2 userX | d | t3 userY | a | t4 userY | b | t5 userY | g | t6 userY | c | t...
-
Tim commented,
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]...
-
Tim commented,
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....
-
Tim created a post,
Removing tuples with the same elements in lists
Hello, assuming I have the following table with sample data (ID is a GROUPBY and list is a GROUPCONCAT of another sheet): ID | list 1 | [a,b,c,c,b,a] 2 | [a,a,a,c,d,b,a] What I want to do now is ...