topic Re: Store fonction in QlikView

Store fonction

patrou38 — Fri, 27 Jan 2017 10:21:40 GMT

bonjour,

est ce que quelqu'un pourrait me dire comment metrre plusieurs tables charges avec des function LOAD dans un meme fichier QVD ?

==> STORE tablesXXXX into fichier de destination.qvd(qvd)

merci d'avance

Re: Store fonction

Anonymous — Fri, 27 Jan 2017 11:06:46 GMT

Bonjour,

Vous pouvez utiliser la fonction concatenate () pour concaténer les tables dans une grande table et ensuite pour télécharger en QVD.

Vous pouvez charger la première table nommée T1, et le second, le troisième, au-dessus CONCATENATE (T1) et la structure de charge avec Load.

Cosmina

Re: Store fonction

patrou38 — Fri, 27 Jan 2017 13:24:10 GMT

merci de ta reponse mais je ne vois pas bien comment et ou metre la function Concatenate.

pourrais tu me donner un exemple base sur le schema ci dessous ?

T1:

Load * from .....xls

T2:

Load * from .....xls

T3:

Load * from .....xls

Store Tx into test.qvd (qvd);

Re: Store fonction

jonathandienst — Fri, 27 Jan 2017 13:34:24 GMT

T1:

Load * from .....xls

Concatenate(T1)

Load * from .....xls

Concatenate(T1)

Load * from .....xls

Store T1 into test.qvd (qvd);

Re: Store fonction

patrou38 — Fri, 27 Jan 2017 13:47:02 GMT

Concatenate is an invalid statement at this point 🙂

Thank you again for your help 🙂

manuf:
LOAD *
FROM
(biff, embedded labels, table is Manuf_2$);
Concatenate('manuf');
manuf2:
LOAD *
FROM
(biff, embedded labels, table is [FEP GIT$]);
Concatenate('manuf');
STORE Manuf into test.qvd(qvd);

Re: Store fonction

vishsaggi — Fri, 27 Jan 2017 14:29:59 GMT

You dont need that second Concatenate there.... Just load this and check.

manuf:
LOAD *
FROM
(biff, embedded labels, table is Manuf_2$);
Concatenate('manuf');
manuf2:
LOAD *
FROM
(biff, embedded labels, table is [FEP GIT$]);

STORE Manuf into test.qvd(qvd);

Store fonction

Re: Store fonction

Anonymous — Fri, 27 Jan 2017 14:37:15 GMT

manuf:

LOAD *

FROM
(biff, embedded labels, table is Manuf_2$);

Concatenate(manuf)
LOAD *
FROM
(biff, embedded labels, table is [FEP GIT$]);

STORE Manuf into test.qvd(qvd);

Re: Store fonction

patrou38 — Fri, 27 Jan 2017 14:37:23 GMT

ok to remove the second one but the first one is not ok... when I execute the script via the reload button, I get an error message "Unknown Statement Concatenate (manuf).

If you can see in the script , the concatenate function should be in Blue as a function.. and here this is not the case.

Please note that I really appreciate your help.

Re: Store fonction

vishsaggi — Fri, 27 Jan 2017 15:00:02 GMT

Dont use ; colon after Concatenate() keyword.

Re: Store fonction

Anonymous — Fri, 27 Jan 2017 15:07:42 GMT

STORE manuf into test.qvd(qvd);

Re: Store fonction

maxgro — Fri, 27 Jan 2017 18:44:29 GMT

this will make a single qvd for an entire data model

Storing a Data Model in a Single QVD | Qlikview Cookbook