topic Re: Left keep - than to replace? in QlikView

Left keep - than to replace?

Fri, 28 Apr 2017 08:06:48 GMT

Hello dear colleagues! Faced the problem - when using the LEFT KEEP I lost the record, I decided to replace the LEFT KEEP on OUTER JOIN, but there was another problem - an error that the following table could not be found. What else can you replace the LEFT KEEP except for an OUTER JOIN?

Tab_1:

left keep(TABLE_2) "I Replace left keep on outer join in this line"

LOAD

fld_1,

fld_2,

fld_3,

fld_4,

fld_5

FROM [$(vPathLoadEvents)]

(qvd);

Dict:

left keep(TABLE_3)

LOAD

fld_1,

fld_2

FROM

(qvd);

Re: Left keep - than to replace?

sunny_talwar — Fri, 28 Apr 2017 08:40:32 GMT

What exactly are you trying to do here? Why do you need Left Keep or Outer Join? Can you elaborate on your requirement?

Re: Left keep - than to replace?

Fri, 28 Apr 2017 08:59:18 GMT

I need to check the values in TABLE_2 when loading from vPathLoadEvents and if there is a value in TABLE_2, then create an entry in Tab_1 by adding values from TABLE_2. But in my case, in TABLE_2 there is no entry for the field fld_1 and I probably need some condition that if I do not find an entry in TABLE_2 the same fields are filled with values from [$ (vPathLoadEvents)]. I wrote very intricately?

Re: Left keep - than to replace?

Peter_Cammaert — Fri, 28 Apr 2017 11:48:18 GMT

Yoor explanation is a bit confusing. In Table_1, do you want to load rows that have a corresponding entry in TABLE_2, or do you want to load rows from the [$(vPathLoadEvents)] data source for which no corresponding entry exists in TABLE_2?

Or do you want to load all rows with a corresponding entry in TABLE_2 from one data source into Table_1, and add all remaining rows - that are missing in TABLE_2 - from the [$(vPathLoadEvents)] data source? In that case it might be easier to use a WHERE Not Exists() clause.

Re: Left keep - than to replace?

Fri, 28 Apr 2017 13:24:03 GMT

Peter, in my case, it is necessary load rows from the [$(vPathLoadEvents)] data source for which no corresponding entry exists in TABLE_2. But I was bewildered myself, because the task was wrongly set and accordingly I could not formulate the question.

I am grateful to you for your sympathy and interest in my problem.

Re: Left keep - than to replace?

Fri, 28 Apr 2017 13:24:16 GMT

I am grateful to you for your sympathy and interest in my problem.