topic Source data stored in elements of array in QlikView

Source data stored in elements of array

raghuvr33 — Fri, 09 Jan 2015 14:31:46 GMT

Hi,

I am having difficulty in getting data from ERP source where sales person is stored in elements of array. Upto four Sales persons are stored in one field slspsn with four elements slspsn[1] , slspsn[2] , slspsn[3] , slspsn[4] . Each of these elements have a different Slsperson data in them. Specifying slspsn[1] in the load statement and sql part of the load statement is throwing errors.

I would appreciate if somebody can guide me how to retrieve this kind of data into QV .

Re: Source data stored in elements of array

Gysbert_Wassenaar — Fri, 09 Jan 2015 16:03:45 GMT

What does the content of the field look like? Is it a text string? Or is it binary data?

Re: Source data stored in elements of array

raghuvr33 — Fri, 09 Jan 2015 16:05:07 GMT

It is text data storing the initials of the sales person

Re: Source data stored in elements of array

Gysbert_Wassenaar — Fri, 09 Jan 2015 16:13:55 GMT

Can you post the complete text string value of one field value?

Re: Source data stored in elements of array

Anonymous — Fri, 09 Jan 2015 16:21:45 GMT

See subfield() function, maybe this is what you need.

Re: Source data stored in elements of array

raghuvr33 — Fri, 09 Jan 2015 17:06:46 GMT

That was it. Many thanks to both of you. Orginally while extracting the data from source erp, only the field name 'slspsn' was specified without any elements of the array. This retrieved all the data from the field delimited by ';'. I did a test and was able to successfuly get the sales persons name from individual elements by using the subfield function in QV.

Thanks again.