Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to join multiple csv files in load?

Please help.

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

4 Replies
Not applicable

Re: How to join multiple csv files in load?

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

Not applicable

Re: How to join multiple csv files in load?

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

load *

from

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

They will be concatenated automatically.

Not applicable

Re: How to join multiple csv files in load?

Tnx, work

oknotsen
Honored Contributor III

Re: How to join multiple csv files in load?

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 .

May you live in interesting times!