Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
patrou38
Creator
Creator

Store fonction

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

10 Replies
Anonymous
Not applicable

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

patrou38
Creator
Creator
Author

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);

jonathandienst
Partner - Champion III
Partner - Champion III

T1:

Load * from .....xls

Concatenate(T1)

Load * from .....xls

Concatenate(T1)

Load * from .....xls

Store T1 into test.qvd (qvd);

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
patrou38
Creator
Creator
Author

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);

vishsaggi
Champion III
Champion III

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);

Anonymous
Not applicable

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);

patrou38
Creator
Creator
Author

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.

vishsaggi
Champion III
Champion III

Dont use ; colon after Concatenate() keyword.

Anonymous
Not applicable

  STORE  manuf into test.qvd(qvd);