topic How to split cell values and create separate records? in QlikView

How to split cell values and create separate records?

Tue, 16 Aug 2016 15:07:04 GMT

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,

Re: How to split cell values and create separate records?

vishsaggi — Tue, 16 Aug 2016 15:56:14 GMT

Try this:

Subfield(QuestionID, '+') AS QuestionID

Re: How to split cell values and create separate records?

vishsaggi — Tue, 16 Aug 2016 15:59:44 GMT

I mean in your Load script like

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

Dimension,

Report

FROM Table1.xlsx ;

Re: How to split cell values and create separate records?

Wed, 17 Aug 2016 08:35:19 GMT

Hi Vish,

Thanks for your solution, it does the trick!

Laleh