topic Re: How to load from multiple text files in QlikView

How to load from multiple text files

mustafaelryah — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I need to load data from many files to one table,

first file name is Transactions All.txt

2nd name is Transactions Methaq.txt

when I load it as4

load....from

(txt, codepage is 1256, embedded labels, delimiter is '\t', msq);

its show me error, how can I solve that plz.

Re: How to load from multiple text files

sunny_talwar — Thu, 07 Apr 2016 12:23:21 GMT

Does the two files follow the same structure and include the same fieldnames?

For difference due to fieldnames or structure, try a for loop:

Load multiple excel files from Multiple excel sheetsinto QV

For each..next ‒ QlikView

Re: How to load from multiple text files

Chanty4u — Thu, 07 Apr 2016 12:24:36 GMT

chk dis

Load from multiple text files (dynamic)

Re: How to load from multiple text files

mustafaelryah — Thu, 07 Apr 2016 12:27:05 GMT

Sure, Same in every thing

Re: How to load from multiple text files

sunny_talwar — Thu, 07 Apr 2016 12:29:23 GMT

There is no 's' in the file names, could that be the issue?

load....from - > load....from

Re: How to load from multiple text files

Colin-Albert — Thu, 07 Apr 2016 12:30:19 GMT

It may be better to create a loop to do the reload rather than using the wildcard *.

If you use a loop, you can add a trace command to list which file is currently being processed and this may help identify the error, whereas the wildcard load does not identify which file is being processed.

It may be that one of the files differs from the others - using a loop would identify this.

Re: How to load from multiple text files

hic — Thu, 07 Apr 2016 12:31:57 GMT

The wildcard in the file name usually works - but not always. Then it is better to use a For - Next loop:

Set vConcatenate = ;
For Each vFile in FileList('D:\QlikView\Transaction*.TXT')
$(vConcatenate)
Load *,
FileName() as FileName
From "$(vFile)"
(txt, codepage is 1256, embedded labels, delimiter is '\t', msq);
Set vConcatenate = Concatenate ;
Next vFile

HIC

Re: How to load from multiple text files

HirisH_V7 — Thu, 07 Apr 2016 12:33:50 GMT

Hi,

Showing error means!

what is the error?

-Hirish

Re: How to load from multiple text files

mustafaelryah — Thu, 07 Apr 2016 12:38:39 GMT

Sorry, the files contains s

Transactions All,

Transactions Methaq

and still I have the error

Re: How to load from multiple text files

sunny_talwar — Thu, 07 Apr 2016 12:50:06 GMT

What is the error you are getting? Can you share the logfile?

Re: How to load from multiple text files

mustafaelryah — Thu, 07 Apr 2016 12:54:22 GMT

Hi dear this seems is right, let me adjust it to my code and I will get back to you soon, thanks a lot

Re: How to load from multiple text files

engishfaque — Thu, 07 Apr 2016 14:01:07 GMT

Dear mm,

You can load all the text file data using listed below code,

Load...from

(txt, codepage is 1256, embedded labels, delimiter is '\t', msq);

Kind regards,

Ishfaque Ahmed

Re: How to load from multiple text files

mustafaelryah — Sun, 10 Apr 2016 08:25:44 GMT

Thanks dear for the helpful answer, but when I applied it on my code the header showing me these red lines:

how can I solve this

With Regards.

Re: How to load from multiple text files

mustafaelryah — Sun, 10 Apr 2016 08:37:54 GMT

Kindly find the below error when I applied this solution:

Re: How to load from multiple text files

mustafaelryah — Sun, 10 Apr 2016 08:50:50 GMT

I tried this solution but it gives me error on the reloading

Re: How to load from multiple text files

Colin-Albert — Sun, 10 Apr 2016 09:18:47 GMT

You cannot combine the preceeding load that is doing the applymap inside a loop.

Load the data in the loop into a temp table first, then use a resident load to generate the final table with the applymap and other commands.

Your example was posted as an image so the complete script is not available to view or copy. It is better to post scripts as text.

Try something like this

Set vConcatenate = ;
For Each vFile in FileList('D:\QlikView\Transaction*.TXT')

     tmpTable:
     $(vConcatenate)
     Load *,
     FileName() as FileName
     From "$(vFile)"
     (txt, codepage is 1256, embedded labels, delimiter is '\t', msq);
     Set vConcatenate = Concatenate ;
Next vFile ;

FinalTable:

load

text(company) & '-' & Text(BranchObject) as #Company ,

// add more commands here

resident tmpTable ;

drop table tmpTable ;

Re: How to load from multiple text files

mustafaelryah — Sun, 10 Apr 2016 09:28:43 GMT

Finally it works, Thanks a lot Colin