topic Re: Duplicate values in QlikView

Duplicate values

satheshreddy — Thu, 06 Jul 2017 06:01:51 GMT

Hi All,

i have data like this AND am getting output like the bellow and i need out put like last table.

please help me on this.

Regards
Sathsih

Re: Duplicate values

ahaahaaha — Thu, 06 Jul 2017 06:16:18 GMT

Hi,

Is it necessary in a script or in UI? And how did you get the table "GETTING Output"?

Regards,

Andrey

Re: Duplicate values

satheshreddy — Thu, 06 Jul 2017 06:19:51 GMT

Hi Andrey,

i have created based on b=2 columns using resident load and am comparing the data.

i need required output

Regards

Sathsih

Re: Duplicate values

satheshreddy — Thu, 06 Jul 2017 06:27:06 GMT

Hi Andrey,

its necessary in Script level why because we are using table box for showing data.

Regards

Sathsih

Re: Duplicate values

Kushal_Chawda — Thu, 06 Jul 2017 07:19:04 GMT

What is the logic get the output you are showing?

Re: Duplicate values

Kushal_Chawda — Thu, 06 Jul 2017 07:31:04 GMT

try this

Data:

LOAD * Inline [

A,B,C,D,E

XYZ,1,110,AAA,1.2

XYZ,1,110,AAA,3.8

XYZ,2,210,AAA,9.2 ];

Left Join(Data)

LOAD A,

min(E) as E,

1 as Flag

Resident Data

Group by A,

Left Join(Data)

LOAD Flag,

B as B1,

C as C1,

D as D1,

E as E1

Resident Data

where B=2;

Final:

NoConcatenate

LOAD *

Resident Data

where B<>2;

DROP Table Data;

DROP Field Flag;

Re: Duplicate values

satheshreddy — Thu, 06 Jul 2017 07:33:28 GMT

Hi Kushal,

using actual data am filtrating based on B column and loading all columns using resident load here am using qualify * and unqualify one column name and then in UI am showing data in Table Box.

FAF.

i need output like last one.

Regards

Sathish

Re: Duplicate values

Kushal_Chawda — Thu, 06 Jul 2017 07:44:26 GMT

try this

Data:

LOAD * INLINE [

A, B, C, D, E

XYZ, 1, 110, AA, 1.2

XYZ, 1, 110, AA, 3.8

XYZ, 2, 210, AA, 9.2

XYZ, 3, 310, AA, 23

];

Left Join(Data)

LOAD A,

min(E) as E,

1 as Flag

Resident Data

Group by A,

Left Join(Data)

LOAD Flag,

B as B1,

C as C1,

D as D1,

E as E1

Resident Data

where B=2;

Left Join(Data)

LOAD Flag,

B as B2,

C as C2,

D as D2,

E as E2

Resident Data

where B=3;

Final:

NoConcatenate

LOAD *

Resident Data

where not match(B,2,3);

DROP Table Data;

DROP Field Flag;

Re: Duplicate values

ahaahaaha — Thu, 06 Jul 2017 07:56:03 GMT

May be like at attached file (to your data, I added one more line)?