interview quetion

[#1]

name            tool

naveen         qlikview,tableu

purush          infruamatica,msbi

i want these table like as(split tool)

naveen        qlikview

naveen         tableu

purush          infruamatica

purush          msbi

for examle

naveen        qlikview

naveen         tableu

purush          infruamatica

purush          msbi

if we use AGGR function for this we can get first table

what is the opposite funtion for AGGR

[Gysbert_Wassenaar · Accepted solution]

load

     name,

     subfield(tool,',') as tool

from ...

[Anonymous]

Hi Naveen,

Please check the attachment for solution