topic Re: applymap file reference in QlikView

applymap file reference

Wed, 11 Nov 2015 15:28:30 GMT

I have the following code:

and when it runs, I get the following error message:

Why is ApplyMap inserting the local disk\folder reference (R:\VC\) before the file reference? All the other references to

Webadmin.dbo.xxxx work fine. I even tried loading the entire Rep file (select * from Webadmin.dbo.Rep) in front of the

ApplyMap statement, and that worked fine. It's only in the ApplyMap that the reference is getting changed.

Any ideas why? Thanks, Kevin.

sunny_talwar — Wed, 11 Nov 2015 15:33:00 GMT

may be you need SQL Select * from in there like other tables.

RepMap:

Mapping

LOAD Rep_UID,

RPC_NAME;

SQL Select *

FROM Webadmin.dbo.Rep;

Wed, 11 Nov 2015 15:43:30 GMT

Hi Sunny,

Thanks, but according to Henric's documentation and the HELP file, that's not needed.

sunny_talwar — Wed, 11 Nov 2015 15:46:58 GMT

I don't see any mention of not needing to use SQL Select *?

Wed, 11 Nov 2015 16:30:07 GMT

According to both sources, the syntax is

Mapping ( loadstatement |selectstatement )

Examples:

Mapping LOAD * FROM x.csv

If I have the LOAD statement (which I do), I don't need a SELECT statement as well.

sunny_talwar — Wed, 11 Nov 2015 16:31:58 GMT

Is Webadmin.dbo.Rep a Excel file? or something from a database?

Wed, 11 Nov 2015 16:36:06 GMT

Webadmin is a database. Hence the file spec: webadmin.dbo.Rep

I have used ApplyMap before and never had this issue.