topic Re: need to split some loaded rows into 2 rows in QlikView

need to split some loaded rows into 2 rows

twills12 — Fri, 20 Nov 2020 18:58:42 GMT

I have some rows I am loading that will need to be split into 2 rows. Unable to get my head around how to accomplish.

Sample data...

Category Date Description

Access 10/1/2020 Incomplete credentials

Access, Data 10/15/2020 Credentials, missing required items

The first record I would reflect with a count of '1' and display the row.

Access 10/1/2020 Incomplete credentials 1.0

The second record I would like to reflect a count of '.5' for 'Access' and '.5' for 'Data' and display 2 rows, breaking each out into something like this...

Access 10/15/2020 Credentials, missing required items 0.5

Data 10/15/2020 Credentials, missing required items 0.5

Any suggestions on how this could be done?

Re: need to split some loaded rows into 2 rows

dplr-rn — Tue, 10 Nov 2020 18:59:15 GMT

Use subfield function.

in your script use this line

subfield(Category,',') as Category

refer this

https://community.qlik.com/t5/QlikView-Documents/The-Secret-Life-of-SubField/ta-p/1479876

Re: need to split some loaded rows into 2 rows

twills12 — Tue, 10 Nov 2020 19:22:05 GMT

Absolutely beautiful! I knew about subfield but didn't think it would be the solution here. Thanks!