How to avoid repetition

aminehaddar — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm new in qlikView.

I need to load 3 files: f1.txt , f2.txt and f3.txt that represent a caption of monthly use.

All of them have the same structure: ID, Date.

I used for all of my files:

LOAD

ID,

'31-12-2017' as Date_Situation

FROM

[.../f3.TXT]

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

LOAD

ID,

'30-11-2017' as Date_Situation

FROM

[.../f2.TXT]

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

LOAD

ID,

'31-10-2017' as Date_Situation

FROM

[.../f1.TXT]

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

and store the result in a newfile.txt.

***The result is that I found repetition of the ID, Here I found 2 or more of the same ID . => the same ID but the date is different.

To sum up, I need to get all the ID without repetition. I mean, if I found repetition of an ID, I should find only the ID for the last situation.

Anyone can help please?

Thanks

Re: How to avoid repetition

lironbaram — Mon, 08 Jan 2018 11:56:47 GMT

try this

LOAD

ID,

'31-12-2017' as Date_Situation

FROM

[.../f3.TXT]

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

LOAD

ID,

'30-11-2017' as Date_Situation

FROM

[.../f2.TXT]

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes)

where not exists(ID);

LOAD

ID,

'31-10-2017' as Date_Situation

FROM

[.../f1.TXT]

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes)

where not exists(ID);

topic How to avoid repetition in QlikView

How to avoid repetition

Re: How to avoid repetition