Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
lzw92
Contributor
Contributor

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

Capture.PNG

 

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?

Labels (5)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

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;

 

split.PNG

View solution in original post

4 Replies
Chanty4u
MVP
MVP

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;

 

split.PNG

MayilVahanan

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R
Gabriel
Partner
Partner

Hi,

 

Load

SUBFIELD(Name,';')                  AS Name,

[Attendee?]

FROM .....;

 

lzw92
Contributor
Contributor
Author

Thank you. This is what I was looking for.