topic Load Distinct on Resident Table in QlikView

Load Distinct on Resident Table

Thu, 25 Jun 2009 18:58:52 GMT

Hi there,

I'm trying to do a Load distinct on a resident table but unfortunatly this doesn't work. I'm wondering if doing such a thing is possible.

Here is my script, if you find any mistake...

ALL_TABLE:

LOAD [DATE] as [Date],

[PRICE] as [Product Price],

[DTINSERTED] as [Insertion Date],

SQL select * from myTable;

DATE_TABLE:

LOAD DISTINCT [Date]

RESIDENT ALL_TABLE;

Thx for your help

Load Distinct on Resident Table

Thu, 25 Jun 2009 19:05:39 GMT

Hi,

There is one mistake.

At the end of field insertion Date you should use ';' semicolon.

your scrpt shoud look like below one.



ALL_TABLE:


LOAD [DATE] as [Date],
[PRICE] as [Product Price],
[DTINSERTED] as [Insertion Date];
SQL select * from myTable;
DATE_TABLE:
LOAD DISTINCT [Date]
RESIDENT ALL_TABLE;

- Sridhar

Load Distinct on Resident Table

Thu, 25 Jun 2009 19:12:23 GMT

Hi,

there is one.

This part of the load works well.

The problem is on the LOAD DISTINCT

Load Distinct on Resident Table

Thu, 25 Jun 2009 19:20:35 GMT

Hi,

Check this attachment.

Distinct key word works well forme

Post your sample here

- Sridhar

Re. :Re: Load Distinct on Resident Table

Thu, 25 Jun 2009 19:23:21 GMT

what's your error message ?

Re. :Re: Load Distinct on Resident Table

Thu, 25 Jun 2009 19:32:13 GMT

Ok Sorry,

My mistake, it works mow thx.