Loading from a resident table

chris_johnson — Fri, 31 Dec 2010 10:38:43 GMT

Hi,

I'm seeing some weird things happening and would like to find out if it's me doing something wrong!

I'm loading some data into a table and then using this to create another table with just the most recent records in:

ResourcePriceTemp: LOAD Code as "Resource No.", "Task Code", "Effective Date", "Unit Price", "Brand Code"; SQL SELECT Code, "Task Code", "Effective Date", "Unit Price", "Brand Code" FROM NAVLive.dbo."Resource Price";

ResourcePrices: load "Resource No.", "Task Code", "Brand Code" as "Resource Brand Code", "Unit Price", max("Effective Date") as "Effective Date" resident ResourcePriceTemp group by "Resource No.", "Task Code", "Brand Code", "Unit Price"; drop table ResourcePriceTemp;

It will create the ResourcePriceTemp table (which it will then drop, I've tried uncommenting the drop table line and it does create this table). It doesn't seem to create the ResourcePrices table though and I've no idea why. Does anyone have any idea?

Regards,

Chris

Loading from a resident table

Miguel_Angel_Baeyens — Fri, 31 Dec 2010 10:50:31 GMT

Hello Chris,

Your syntax seems fine to me. Try using NOCONCATENATE before the LOAD in ResourcePrices, just in case it's being concatenated to ResourcePriceTemp, then dropped.

Hope this helps.

Loading from a resident table

chris_johnson — Fri, 31 Dec 2010 11:02:19 GMT

Yes, looks like it may be doing that. May have somehow fixed it just by renaming a few fields but I'm sure you're suggestion would have worked also.

Chris

topic Loading from a resident table in QlikView

Loading from a resident table

Loading from a resident table

Loading from a resident table