Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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;

Highlighted
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

Highlighted

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.

Highlighted

Re: applymap file reference

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

Highlighted
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.