topic Re: Loop in a script in QlikView

Loop in a script

JR_38 — Fri, 26 Apr 2024 15:57:19 GMT

Hi all,

i would need your help on this topic:

I am getting following Data under Qlikview:

I would like to assign the field-information from "AREA-EAN" when the Datatyp='AREA' as own column for the following eans, and then remove the line related to the datatyp "AREA" .

It should look like this:

I set different variables in order to use it in my first loop but the for...next doens´t work.

INV_RAWDATA:

LOAD * INLINE [

ID, Datatyp, AREA_EAN, Qty

1, AREA, A-30-D-00, 1

2, EANS, 4062171924956, 2

3, EANS, 4062171874947, 2

4, EANS, 4062171912946, 1

5, EANS, 4062171924956, 1

6, EANS, 4062171924956, 1

7, AREA, A-29-D-00, 1

8, EANS, 4062171874930, 1

9, EANS, 4062171912946, 1

10, EANS, 4066952504313, 1

11, EANS, 4066952504320, 1

12, EANS, 4066952504320, 1

13, EANS, 4066952504320, 1

];

Store INV_RAWDATA into File.qvd;

// set Variable with information

VARIABLE_I:

set i=1;

LOAD ID,

AREA_EAN,

Datatyp,

Qty

FROM File.qvd (qvd) where ID=$(i) and Datatyp='AREA';

let i=$(i)+1;

let AREA=peek('AREA_EAN',0,'VARIABLE_I');

VARIABLE_II:

LOAD

max(ID) as max_i

FROM

File.qvd (qvd);

let max_i=peek('max_i',0,'VARIABLE_II');

FOR i=$(i) to max_i=$(max_i)

RUN:

LOAD

'$(AREA)' as AREA,

ID,

AREA_EAN,

Datatyp,

Qry

FROM

File.qvd (qvd) ;

Has somebody any idea how I could get the desired result?

Re: Loop in a script

rubenmarin — Sat, 27 Apr 2024 06:42:13 GMT

Hello, this script gets the result table:

OrigData: LOAD * INLINE [ ID, Datatyp, AREA_EAN, Qty 1, AREA, A-30-D-00, 1 2, EANS, 4062171924956, 2 3, EANS, 4062171874947, 2 4, EANS, 4062171912946, 1 5, EANS, 4062171924956, 1 6, EANS, 4062171924956, 1 7, AREA, A-29-D-00, 1 8, EANS, 4062171874930, 1 9, EANS, 4062171912946, 1 10, EANS, 4066952504313, 1 11, EANS, 4066952504320, 1 12, EANS, 4066952504320, 1 13, EANS, 4066952504320, 1 ]; ProcessData: NoConcatenate LOAD ID, Datatyp, If(Datatyp='EANS', Peek(AREA_EAN), AREA_EAN) as AREA_EAN, Qty Resident OrigData; DROP Table OrigData; FinalData: NoConcatenate LOAD * Resident ProcessData where Datatyp='EANS'; DROP Table ProcessData;

Re: Loop in a script

JR_38 — Sat, 27 Apr 2024 19:33:54 GMT

exactly what I wanted and so an easy way to solve the problem, thanks Rubenmarin