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.