Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this Mapping Table..
fbFetCosecha:
Mapping LOAD t_fdat,
t_edat,
t_gpci,
codCosecha
FROM TablafnGetCosecha.qvd (qvd);
And I need applymap in load.
I have 2 fiels, and I need codCosecha
I have this codition to applymap:
-date between t_fdat and t_edat
-group = t_gpci
How I can do the applymap?
HELP PLEASE
Hi,
You can't use the Mapping Functions in this case.
Mapping Table must have two fields.
If you want to join 2 tables with a date interval, you have to use IntervalMatch() Function.
I invite you to consult QV's help (F1) to have more informations on IntervalMatch().
Hope that helps you
Martin Favier
I can't join :s
Do you know how to load from a qvd in vbscript?
You can only load a QVD with QlikView !
Martin Favier
But you can launch a QV task with a .bat file.
The .bat wich be used in your VBScript.
Martin Favier
Any example? :s
The command line in the batch file would be :
"C:/Program Files/QlikView/Qv.exe" /r "C:/QlikView/MyApp.qvw"
You'll find more informations in QV help (F1).
Martin Favier
Have a look at this blog. It may be of use to you. Steve has a number of useful blogs and videos on his site for beginners.
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Regards,
Neil.