topic Re: How to join multiple csv files in load? in QlikView

How to join multiple csv files in load?

Thu, 14 Jul 2016 16:40:47 GMT

Please help.

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

Re: How to join multiple csv files in load?

Fri, 15 Jul 2016 00:33:49 GMT

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

Re: How to join multiple csv files in load?

Fri, 15 Jul 2016 00:46:36 GMT

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

load *

from

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

They will be concatenated automatically.

Re: How to join multiple csv files in load?

Fri, 15 Jul 2016 07:12:20 GMT

Tnx, work

Re: How to join multiple csv files in load?

oknotsen — Fri, 15 Jul 2016 07:32:09 GMT

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 .