Hi all, I need to count the unique values of each row i have in my search (maybe this sounds abstract to you), the data i have in my cells are separated by "," . Here is an example: ID | A | B 1 | a,b,c | 3 ("a","b","c" are unique here) 2 | a,d | 1 ("a" has been already found, so the only unique value is "d") 3 | b,k,e | 2 ("b" has been already found, only unique values are "k" and "e") I tried to run dedup and rex field , but cannot get the search right. could anyone help? One more question , is it possible to duplicate the row but only in each line i find only one value (example): ID | A | A_mod 1 | a,b,c | a 1 | a,b,c | b 1 | a,b,c | c ---------------------------------------- 2 | a,d | a 2 | a,d | d ----------------------------------------- 3 | b,k,e | b 3 | b,k,e | k 3 | b,k,e | e Sorry if i posted two questions, i am just asking about the possibility and how to achieve it. I thought of this exemple because it might get easier by then to run dedup
... View more