How to split cell values and create separate records?

[#1]

Hi There,

Below is the screenshot of a spreadsheet I am trying to load into QlikView.

Basically, I have to split the Question ID values where two or more question IDs are joined with a + sign and create the below table to tell Qlik that these question IDs belong to the same dimension and report values.

Can someone help me achieve this?

Many Thanks,

[vishsaggi]

Try this:

Subfield(QuestionID, '+') AS QuestionID

[vishsaggi · Accepted solution]

I mean in your Load script like

LOAD Subfield(QuestionID, '+') AS QuestionID,

          Dimension,

          Report

FROM Table1.xlsx ;

[#4]

Hi Vish,

Thanks for your solution, it does the trick!

Laleh