First off, you'd have to change the double quotes to single quotes so it's possible do identify a single field from your csv for the Example1, Example2, ... field.
On your original file, all of the Example values should be enclosed by single quotes, like:
'Example1, Example2, Example4, Example5'
Second, once you load that up, you'll just have to use the subfield() statement to separate all the "Example"s into one field.
For the dummy data in the teste.csv file attached, the following code:
trim(subfield(Col4,',')) as Teste
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Gets the following in Qlik:
one solution might be:
tabTests: LOAD RecNo() as TestID, * INLINE [ Test10 "Example1, Example2, Example4, Example5" "Example1, Example4, Example5, Example6" "Example1, Example2, Example6" "Example2, Example4" "Example1, Example2, Example4, Example5, Example7" ]; tabExamples: LOAD TestID, Trim(SubField(Test10,',')) as NewColumn Resident tabTests;
hope this helps
QlikCommunity_Thread_285061.qvw 154.0 K
The Subfield will create additional rows based on how many delimiters the field has, on my example:
A,111,01/01/2017,'Example1, Example2, Example4, Example5'
B,2,02/01/2017,'Example1, Example2, Example3'
Col1 Col2 Col3 Teste
A 111 01/01/2017 Example1
A 111 01/01/2017 Example2
A 111 01/01/2017 Example4
A 111 01/01/2017 Example5
B 2 02/01/2017 Example1
B 2 02/01/2017 Example2
B 2 02/01/2017 Example3
Depending on how many combinations you have (you mentioned some up to 100) it can increase your data a lot.