You could explode table B on menu group and then do an array contains join comparison where Group from table A […]contains Menu_group from Table B. After the join you can add a transform to aggregate the result by grouping by menu and doing a collect array on the user field.
Hm I tried with the example you had in your first message and it looks like the output matches what you’re expecting (see screenshots below). I would double check that the joins are using the correct columns names?
Hi Helenq, Thank you very much for your patient and clear guide. I think something wrong with the Array working in my Laptop. I just create a single table with Array and search contain seems it also does not work properly.
Oh I see it looks like you end up creating arrays with length 1. For example in your first row you have an array with one element [“a, b, c”] instead of and array with three elements [“a”, “b”, “c”]
Can you create an array by using the split string transform? And use the comma “,” as the separator
Great thanks helenq. It is working by using split string.