Add a new row using a delimiter split on a specific column.

[lzw92]

Assuming I am unable to manipulate the data within Qlik, say if I got a row of data, but if there is a delimiter ";", split and create a new row as shown above?

Is this possible and what is the easiest way to do so?

[Chanty4u · Accepted solution]

is this you are looking at?

Source_Data:
Load * Inline [
Group_Id,Items
1,"Peter;Aron"
2,"Ram;Shiv"
];

NoConcatenate
LOAD
Group_Id,
SubField(Items,';') as Items
Resident Source_Data;

Drop Table Source_Data;

[MayilVahanan]

Hi

Try like this

Load SubField(Name,';') as Name, Attendee? Inline
[
Name, Attendee?
Tom, Y
John, Y
Peter;Aaron, N
];

[Gabriel]

Hi,

Load

SUBFIELD(Name,';')                  AS Name,

[Attendee?]

FROM .....;

[lzw92]

Thank you. This is what I was looking for.