topic Re: Split a field into multiple rows with values from other fields in QlikView

Split a field into multiple rows with values from other fields

helen_pip — Tue, 25 Jun 2019 09:29:45 GMT

Dear Qlikview user

I have a data structure issue which I am trying to resolve and was wondering if someone could kindly point me in the right direction

I have a table of data which looks as follows

Session ID Reason Patients

123456 No Staff 123

What I hope to achieve from a table structured as follows is the following:

Session ID Reason Patients

123456 No Staff 1

123456 No Staff 2

123456 No Staff 3

I have had a play with substring count but cannot seem to get the desired results....If you could kdinly offer any guidance that would be greatly appreciated

Kind Regards

Helen

Re: Split a field into multiple rows with values from other fields

tresB — Tue, 25 Jun 2019 09:43:43 GMT

Is it so that the resultant Patients would always have single digit number? If so, try like:

Load [Session ID], Reason, Mid(Patients, IterNo(),1) as Patients While Len(Patients)>=IterNo(); Load * Inline [ Session ID, Reason, Patients 123456, No Staff, 123]

Re: Split a field into multiple rows with values from other fields

helen_pip — Tue, 25 Jun 2019 10:00:39 GMT

Hello,

Thank you so much as this works a treat! I have tried it with my real data and get the desired results

Kind Regards

Helen