topic Re: Splitting rows in Script in QlikView

Splitting rows in Script

Mon, 12 Oct 2015 20:27:21 GMT

Hi,

I have an excel file which contains ID and other fields. ID contains multiple values in it. I need to separate each row based on ID.

Example:

ID Value

1,2,3 100

4,5,6 200

7,8,9 300

Output:

ID Value

1 100

2 100

3 100

4 200

5 200

6 200

7 300

8 300

9 300

Can any one tell me a way to achieve this.

Thanks

Re: Splitting rows in Script

sunny_talwar — Mon, 12 Oct 2015 20:30:59 GMT

Try using the Subfield() function:

Table:

LOAD * Inline [

ID | Value

1,2,3 | 100

4,5,6 | 200

7,8,9 | 300

] (delimiter is |);

NewTable:

NoConcatenate

LOAD SubField(ID, ',') as ID,

Value

Resident Table;

DROP Table Table;

Update1: Forgot to add NoConcatenate

Update2: Sample Attached

Re: Splitting rows in Script

Mon, 12 Oct 2015 20:33:21 GMT

Thank you. It's working the way I need.

Re: Splitting rows in Script

sunny_talwar — Mon, 12 Oct 2015 20:34:08 GMT

Awesome

I am glad I was able to help.

Best,

Sunny