topic Re: Load filter in QlikView

Load filter

Thu, 17 Dec 2015 03:12:09 GMT

Hi,

I wish to load into QVD from Oracle View with selected value, I tried below but failed, please help. Thank you.

[TableName]:

LOAD *

SQL SELECT *

FROM VIEW_NAME ;

WHERE date >='2014-12-31'

STORE TableName into new.qvd;

Re: Load filter

sunny_talwar — Thu, 17 Dec 2015 13:18:40 GMT

Try this:

[TableName]:

LOAD *

SQL SELECT *

FROM VIEW_NAME

WHERE date >='2014-12-31';

STORE TableName into new.qvd;

You misplaced your semi-colon after the FROM statement instead of using it after the WHERE statement.

Re: Load filter

Thu, 17 Dec 2015 13:19:09 GMT

can you be more specific with what failed? did you not get the expected results or was an error displayed when the load script was run?

Re: Load filter

ramasaisaksoft — Thu, 17 Dec 2015 13:24:01 GMT

Hi Andros,

You did a small mistake i.e you can't close/Stop the query (;) before where condition it needs to be close after where condition.

try the below one

[TableName]:

LOAD *

SQL SELECT *

FROM VIEW_NAME

WHERE date >='2014-12-31';

STORE TableName into newTable.qvd(QVD);

Re: Load filter

Thu, 17 Dec 2015 13:27:01 GMT

I was making the assumption what was being shown was not the actual code, but if it is, then I agree there are the syntax errors described above

Re: Load filter

Thu, 17 Dec 2015 13:29:40 GMT

Hi Andros, try this:

Try this:

[TableName]:

LOAD *

SQL SELECT *

FROM VIEW_NAME

WHERE date >='2014-12-31';

STORE TableName into new.qvd;

You were putting the ' ; ' in the incorrect place.

I hope that it help you!

Regards, Agustin

Re: Load filter

Fri, 18 Dec 2015 01:54:28 GMT

Hi Agustin,

I was trying to store the data into QVD from a Oracle View. Anyway I will jut do a filter when loading into Table then. Thank you.

Another question :

In the script below, the OMSPO# consist of PO no like :

000123

000123-1

000123-2

000234

000234-1

000234-2

023123

0123123

But I only want to lad those PO no. without '-' as these are sub-PO.

meaning I only wants to load 000123, 00234, 023123, 0123123.

Appreciate your help.

[Shipment]:
load
fileNumber, orderNumber, primaryReference,
primaryReference as OMSPO#,
serviceLevel as TransportMode,
departmentCode as Department,
creationEmployeeName as LoginUser,
statusCode as POStatus
FROM [Shipments.qvd] (qvd);

Re: Load filter

sunny_talwar — Fri, 18 Dec 2015 11:17:21 GMT

Try this:

[Shipment]:

LOAD fileNumber, orderNumber, primaryReference,

primaryReference as OMSPO#,

serviceLevel as TransportMode,

departmentCode as Department,

creationEmployeeName as LoginUser,

statusCode as POStatus

FROM [Shipments.qvd] (qvd)

Where Len(Trim(KeepChar(primaryReference, '-'))) = 0;

Re: Load filter

sunny_talwar — Fri, 18 Dec 2015 11:21:25 GMT

Sample:

Table:

LOAD primaryReference as [OMSPO#]

Where Len(Trim(KeepChar(primaryReference, '-'))) = 0;

LOAD * Inline [

primaryReference

000123

000123-1

000123-2

000234

000234-1

000234-2

023123

0123123

];