How to join multiple csv files in load?

[#1]

Please help.

I have problem, I need to success join by key multiple csv files (three and more)?

[#2]

when you read a multiple csv files and they have a key and the name os fiels are the same your join are do automaticaly.

you now how read a files?

example below

table:

LOAD fild1,

     keytablea as key

FROM

(ooxml, embedded labels, table is [Plano de Horas]);

Left Join(table)

temp:

LOAD fild2,

     keytableb as key

FROM

(ooxml, embedded labels, table is Cronograma);

[#3]

if they are of the same structure, do a wildcard load.

load *

from

[../abc/cde*.txt];

They will be concatenated automatically.

[#4]

Tnx, work

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .