This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
is this you are looking at?
Source_Data:Load * Inline [Group_Id,Items1,"Peter;Aron"2,"Ram;Shiv"];
NoConcatenateLOADGroup_Id,SubField(Items,';') as ItemsResident Source_Data;
Drop Table Source_Data;
View solution in original post
Try like this
Load SubField(Name,';') as Name, Attendee? Inline[Name, Attendee?Tom, YJohn, YPeter;Aaron, N];
SUBFIELD(Name,';') AS Name,
Thank you. This is what I was looking for.