Hello good people of Domo
Very frustrated trying to remove duplicates WITHIN a comma seperated list. I have the following webform:
If I 'Group By' (Magic ETL) by 'Who' & 'Manufacturer' (combining 'Model' & 'Colour' with commas) I get the below. This has repeats in R5:C3 (2x 'TT'), R6:C3 (2x V70) and 'Black' is repeated in R5:C4 & R6:C4.
What I would like: The above without the duplicates in the cells mentioned.
Other things you might need to know:
- My real data has nearly 1,000,000 rows in it.
- I will not know (ahead of time) what the value will be
- There could be one value, two values or any number of values separated by the comma. I won't know.
I've tried daisy chaining multiple 'Group By' tiles together; I've tried pulling data out, dealing with it and joining it back later (gets messy).
I'm happy to do this in ETL (my preference) but could do it in beast mode if better.
Any ideas, please?
Thanks Domos
Charlie