topic Re: How to work with array fields? in QlikView

How to work with array fields?

Tue, 08 Oct 2013 12:06:37 GMT

Guys, good morning!

I have a problem working with DATASUL, and a table of movement payroll I have 3 array where fields are delimited by ';' are the event codes, quantity and value of the event event. How can I separate this array making each event code is a record and comes with its value and quantity? The field is represented as the example below:

cdn_evento_fp -> 001, 031, 800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0; ...

qtd_event_fp -> 180, 40, 220, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0; ...

val_event_fp -> 1000.00, 200.00, 1200, 00, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...

Re: How to work with array fields?

MK_QSL — Tue, 08 Oct 2013 12:07:25 GMT

use subfield funtion.

Re: How to work with array fields?

Tue, 08 Oct 2013 12:12:13 GMT

I used, but it did not work is returning the wrong values and quantities

Re: How to work with array fields?

MK_QSL — Tue, 08 Oct 2013 12:14:45 GMT

if possible upload your file...

Re: How to work with array fields?

Tue, 08 Oct 2013 12:24:59 GMT

Manish, thank you for help me... but I got it! I used wrong sintax, You you were right!

Re: How to work with array fields?

rbecher — Tue, 08 Oct 2013 12:34:37 GMT

Hello Hugo,

you can use a combination of subfield and LOAD While:

RawData:
LOAD * INLINE [
    cdn_evento_fp, qtd_event_fp, val_event_fp
    "001, 031, 800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0", "180, 40, 220, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0", "1000.00, 200.00, 1200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0"
];

ResultData:
NOCONCATENATE LOAD 
    subfield(cdn_evento_fp, ',', IterNo()) as cdn_evento_fp,
    subfield(qtd_event_fp, ',', IterNo()) as qtd_event_fp,
    subfield(val_event_fp, ',', IterNo()) as val_event_fp    
Resident RawData
While subfield(cdn_evento_fp, ',', IterNo())>0;

Drop Table RawData;

- Ralf

Re: How to work with array fields?

Tue, 08 Oct 2013 12:41:20 GMT

Thank you!

So it was easier than what I did.

Re: How to work with array fields?

Thu, 13 Mar 2014 03:07:43 GMT

Hugo!,

how did you connect with datasul? with ODBC? did you buy any license?

does the database has a password?

Re: How to work with array fields?

Thu, 13 Mar 2014 13:27:47 GMT

I use ODBC connection with User name and password to the database, which is usually sysprogress. And no need to buy to use the ODBC license.