Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

applymap file reference

I have the following code:

repcode.PNG

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

rep.png

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.

6 Replies

Re: applymap file reference

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;

Not applicable

Re: applymap file reference

Hi Sunny,

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

Don't join - use Applymap instead

Re: applymap file reference

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

Not applicable

Re: applymap file reference

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.

Re: applymap file reference

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

Not applicable

Re: applymap file reference

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

I have used ApplyMap before and never had this issue.

Community Browser