Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Je n'arrive pas à concaténer deux tables issues d'une première concaténation automatique :
Table1:
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
Table 2 :
OUTER JOIN (Table1)
LOAD
D,
E,
F,
FROM
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
OUTER JOIN (Table1)
LOAD
D,
E,
F,
FROM
[\\cnedorg\dg-applications\ecommerce2014.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
Je veux obtenir une table avec les données A, B, C, D, E, F mais ça ne me ramène pas les données du fichier ecommerce2014.csv
Merci de votre aide.
Anne
Table1:
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
concatenate
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
noconcatenate
////// /// Table 2//////////////////////////////
Table 2 :
LOAD
D,
E,
F,
FROM
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
concatenate
LOAD
D,
E,
F,
FROM
[\\cnedorg\dg-applications\ecommerce2014.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
///////////////////////////////TABLE 1 +TABLE2//////////////////////////////////////:
noconcatenate
TABLE:
LOAD
A,
B,
C,
D
RESIDENT TABLE1;
outer join
LOAD
D,
E,
F,
RESIDENT TABLE2;
DROP TABLE TABLE1;
DROP TABLE TABLE2;
Bonjour Anne,
Est ce que votre champ "D" permet de distinguer les données d'ecommerce de 2013 et celles de 2014
Si ce n'est pas le cas normal que la dernière jointure n'update aucune valeur de la table "Table1"
try this:
Table2 :
LOAD
D,
E,
F
FROM
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
concatenate
LOAD
D,
E,
F
FROM
[\\cnedorg\dg-applications\ecommerce2014.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
Table1:
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
concatenate
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
outer join
LOAD
D,
E,
F
resident Table2;
drop table Table2;
je croix comme ca mais si vous ajoute votre fichier (.qvw) avec les données nous pouvons essayer (pardon mon francais de l'ecole, sans accents, .....)
Table1:
LOAD
A,
B,
C,
D,
2013 as Year
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
OUTER JOIN (Table1)
LOAD
D,
E,
F,
2013 as Year
FROM
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
Tmp2014:
NoConcatenate
LOAD
A,
B,
C,
D,
2014 as Year
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
OUTER JOIN (Tmp2014)
LOAD
D,
E,
F,
2014 as Year
FROM
[\\cnedorg\dg-applications\ecommerce2014.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
Concatenate (Table1)
load * Resident Tmp2014;
DROp Table Tmp2014;
Table1:
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
concatenate
LOAD
A,
B,
C,
D
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
noconcatenate
////// /// Table 2//////////////////////////////
Table 2 :
LOAD
D,
E,
F,
FROM
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
concatenate
LOAD
D,
E,
F,
FROM
[\\cnedorg\dg-applications\ecommerce2014.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);
///////////////////////////////TABLE 1 +TABLE2//////////////////////////////////////:
noconcatenate
TABLE:
LOAD
A,
B,
C,
D
RESIDENT TABLE1;
outer join
LOAD
D,
E,
F,
RESIDENT TABLE2;
DROP TABLE TABLE1;
DROP TABLE TABLE2;