Mapping - ApplyMap

[farolito20]

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

[martin59]

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

[farolito20]

I can't join :s

Do you know how to load from a qvd in vbscript?

[martin59]

You can only load a QVD with QlikView !

Martin Favier

[martin59]

But you can launch a QV task with a .bat file.

The .bat wich be used in your VBScript.

Martin Favier

[farolito20]

Any example? :s

[martin59]

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

[ngulliver]

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.