Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
twills12
Contributor II
Contributor II

need to split some loaded rows into 2 rows

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?

 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

 

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

 

twills12
Contributor II
Contributor II
Author

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