topic Re: Having trouble with loading a data in QlikView

Having trouble with loading a data

Thu, 22 Jan 2015 16:28:43 GMT

Hi everyone,

I have the following script that combines serveral data sources into one fact table, like this:

OpenItemsTemp:

LOAD CRDATTIM,
CRDATE,
EVNTTIME,
EVNTNSECS,
EVENTCODE,
UNITCD,
WRKTYPE as ProcessName,
STATCD,
QUEUECD,
Right(INXFLD01,1)&''&Num(Left(INXFLD01,9)) as SchemeNo,

UniqueKey;
SQL SELECT *
FROM FPWFI.AWDFPPWH.BI0001;

Left

Join(OpenItemsTemp)
LOAD UniqueKey,
'N' & DATAVALUE as NGSSchemeNo;
SQL SELECT *
FROM FPWFI.AWDBSPDB.W01U999S;

Now I have the fact table loaded, I want to load that again but only if SchemeNo starts with an 'F' or NGSSchemeNo starts with an 'N'. This is the bit I'm getting stuck with, I've tried a resident load but I can't get it to work, any suggestions?

Re: Having trouble with loading a data

Anonymous — Thu, 22 Jan 2015 16:32:48 GMT

Tmp:

noconcatenate load *

resident OpenItemsTemp

where left(NGSSchemeNo,1)='N' and left(SchemeNo,1)='F')

drop table OpenItemsTemp

rename table Tmp to OpenItemsTemp

Re: Having trouble with loading a data

alexandros17 — Thu, 22 Jan 2015 16:34:27 GMT

After you load do:

OpenItems:

noconcatenate

Load * resident OpenItemsTemp where Left(SchemeNo,1)= 'F' or Left(NGSSchemeNo,1)='N';

Drop table OpenItemsTemp;

Let me know

Re: Having trouble with loading a data

MarcoWedel — Thu, 22 Jan 2015 16:45:12 GMT

Hi,

you might also append these lines to your script:

Right Join (OpenItemsTemp)
LOAD UniqueKey
Resident OpenItemsTemp
Where SchemeNo like 'F*' or NGSSchemeNo like 'N*';

hope this helps

regards

Marco

Re: Having trouble with loading a data

Thu, 22 Jan 2015 17:18:33 GMT

Thanks for the help chaps, it's working as expected now.

I was missing the no conatenate in what I was trying to get to work!

Re: Having trouble with loading a data

MarcoWedel — Thu, 22 Jan 2015 23:06:55 GMT

Good to hear.

Please go ahead and close this thread.

thanks

regards

Marco