Discussion Board for collaboration on QlikView Scripting.
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.
may be you need SQL Select * from in there like other tables.
SQL Select *
Thanks, but according to Henric's documentation and the HELP file, that's not needed.
Don't join - use Applymap instead
I don't see any mention of not needing to use SQL Select *?
According to both sources, the syntax is
Mapping ( loadstatement |selectstatement )
Mapping LOAD * FROM x.csv
If I have the LOAD statement (which I do), I don't need a SELECT statement as well.
Is Webadmin.dbo.Rep a Excel file? or something from a database?
Webadmin is a database. Hence the file spec: webadmin.dbo.Rep
I have used ApplyMap before and never had this issue.