Hi. I should lose points for asking this, it's such a simple question, but I keep getting a load error.
I have a table Table1 like:
I want to create the following Table2:
load distinct column_1 as column_a,
concat(column_2,',') as column_b
The above doesn't work. What should I be using?