topic Multi Value Fields in QlikView

Multi Value Fields

Thu, 27 Aug 2009 23:47:32 GMT

I am new to QlikView and still trying to find my way around a little, prior to attending a training course.

I have a delimited text file data set which in some fields contains mutiple values (sub fields), but I don't know how to deal with it.

Is there a good way for dealing with multi-value fields?

An example record from my data set is as follows:

CARPC|12747ý12815|SALESýRECPT|26473ý-26473|26473|CUST CARPC/0474üPO TY032050ýCK LK||0305ý0307||1||15|1|006000||3943|0|12822|||12783

The pipe character | is the field delimiter and the ý is the sub-value/sub-field delimiter.

Any help from anyone would be appreciated.

Many thanks.

Andrew Longland

Multi Value Fields

Thu, 27 Aug 2009 23:57:44 GMT

subfield(bigfield, '|' ,1) as Field1,
subfield(bigfield, '|' ,2) as Field2,

etc

Multi Value Fields

Fri, 28 Aug 2009 13:33:11 GMT

Thank you, but what if there are an unlimited and unknown number of subvalues within each field?

Multi Value Fields

Fri, 04 Sep 2009 04:20:46 GMT

Can anyone answer this for me please???

Multi Value Fields

johnw — Fri, 04 Sep 2009 05:47:47 GMT


Andrew Longland wrote:but what if there are an unlimited and unknown number of subvalues within each field?

I don't know. What if there are? What do you want to happen?

Providing an example record from your data set was a nice starting point. But you didn't tell us what the fields in the record are, whether there's a fixed number or a variable number, how you wanted the resulting fields named, or if you wanted them to be rows in a (field,value) pair sort of table, and then there are similar questions with all the sub fields of the sub fields. The example record itself, being mostly meaningless codes, provides no answers to these questions.

So I have no idea what you want. If that's your example record, what do you want the OUTPUT to look like? How are we supposed to tell you how to get your desired output if you don't tell us what your desired output IS?

Alternatively, you could look up the subfield() function in the help text. It describes two different modes of use. Dragonauta demonstrates the first, when you can assign a specific subfield to a specific field. There's another mode where you can create a ROW of data for every sub field. I suspect that some combination of the two is what you're after.

Here's what is essentially a random example of subfields with subfields. I have no idea if this is what you're after.