topic Re: Qv table (field) transformation in QlikView

Qv table (field) transformation

pamaxeed — Mon, 05 May 2014 12:56:12 GMT

Hi,

i need some help to get rid with this issue.

I have a table with n fields in my .qv application.

The field x in my table can contain the following value "50% = 430501, 50% = 440511"

My task should to parse this value and in the case it contains more elements (think it like a string array) split it into n (2 in the example i gave above) records (with deliimiter is ',').

How i can accomplish it in .qv?

Input: Field value array with the following format "50% = 430501, 50% = 440511"

Output: n records for n elements in the array

Thanks,

Patric

Re: Qv table (field) transformation

hic — Mon, 05 May 2014 13:02:03 GMT

The Subfield function will loop through the string, and create one record per value:

Subfield( <Field>, ',' ) as NewField

HIC

Re: Qv table (field) transformation

pamaxeed — Mon, 05 May 2014 13:05:15 GMT

Thanks!

It was more easy as i thought