topic Re: Script Problem in QlikView

Script Problem

andrea90casa — Fri, 22 Dec 2017 13:13:45 GMT

Hi at all,

I have a situation in which i have to check a dataset like the following one:

Cod_Customer	Cod_Doc
A600	DDT
A600	FAE
A600	FAXN
B150	FAXN
B150	FAX
C300	DDT
C302	DDT
D400	FAX
D402	FAX
E900	FAE

I would like to create a script code in order to generate a new table with only the Cod_Customer record that don't have a DDT or FAE as Cod_Doc.

For example in this case the new table should be like this one

Cod_Customer
B150
D400
D402

Any idea about how to solve it?

Thanks in advance

Andrea

Re: Script Problem

maxgro — Fri, 22 Dec 2017 13:28:48 GMT

Source:

LOAD

FROM

[https://community.qlik.com/thread/285960]

(html, codepage is 1252, embedded labels, table is @1)

;

left join (Source)

LOAD

Cod_Customer,

1 as FlagExclude

RESIDENT Source

WHERE

match(Cod_Doc, 'DDT', 'FAE');

Final:

LOAD

Distinct Cod_Customer

Resident Source

Where NOT Alt(FlagExclude, 0);

Re: Script Problem

pradosh_thakur — Fri, 22 Dec 2017 13:32:03 GMT

table1:

load * inline [

Cod_Customer,Cod_Doc

A600,DDT

A600,FAE

A600,FAXN

B150,FAXN

B150,FAX

C300,DDT

C302,DDT

D400,FAX

D402,FAX

E900,FAE

];

table2:

load distinct if(sum(match(trim(Cod_Doc),'DDT','FAE'))=0,Cod_Customer) as Cod_Customer

resident table1

group by Cod_Customer

;

Re: Script Problem

vishsaggi — Fri, 22 Dec 2017 13:40:17 GMT

May be try this?

Cod:

LOAD Cod_Customer,

Cod_Doc

FROM

[https://community.qlik.com/thread/285960]

(html, codepage is 1252, embedded labels, table is @1);

INNER JOIN (Cod)

LOAD Cod_Doc

Resident Cod

WHERE NOT Match(Cod_Doc, 'DDT', 'FAE');