Load Distinct on Resident Table

[#1]

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

[#2]

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

[#3]

Hi,

there is one.

This part of the load works well.

The problem is on the LOAD DISTINCT

[#4]

Hi,

Check this attachment.

Distinct key word works well forme

Post your sample here

- Sridhar

[#5]

what's your error message ?

[#6 · Accepted solution]

Ok Sorry,

My mistake, it works mow thx.