topic Re: many files with same fields in QlikView

many files with same fields

navaneeth79 — Tue, 06 Feb 2018 11:12:20 GMT

I have many files with same field names and I want to load all the files into same table in qlikview script and all the data gets reflected.

Re: many files with same fields

big_dreams — Tue, 06 Feb 2018 11:27:24 GMT

what was your issue???

use concatenate to concate tables

Load * from table1;

concatenate

Load* from table2;

and so on..

If you want to loop it search for how to use loop in script.

Regards,

Re: many files with same fields

sunny_talwar — Tue, 06 Feb 2018 13:03:47 GMT

You can use For Next loop to load your files

Loops in the Script

Re: many files with same fields

navaneeth79 — Wed, 07 Feb 2018 08:02:29 GMT

i have few files for example 5 files with file name ABC_ddmmyyyy.xlsx where ddmmyyyy referes to date and this changes according to the file extraction.

the code I used is

load

fileds

from(:path/ABC_*.xlsx);

but I can see data only from the first file

Re: many files with same fields

techvarun — Wed, 07 Feb 2018 08:07:20 GMT

Are you using Drop statement everywhere?

The tables with same fields gets concatenated and will be dropped on a single drop statement.

in this case use no concatenate before load script to keep the tables.

If it Doesn't solve your problem then explain the issue in detail.

Re: many files with same fields

techvarun — Wed, 07 Feb 2018 08:13:07 GMT

Check the tab name in the excel sheet. it should be same to extract the data

Re: many files with same fields

sunny_talwar — Wed, 07 Feb 2018 12:18:31 GMT

Share 2 or 3 files and may be we can show you how it can be done.

Re: many files with same fields

big_dreams — Thu, 08 Feb 2018 07:17:35 GMT

Can you post your entire script over here.

In your script add fileName() as fileName, So that you will get to know which file you are loading.

Regards,

Re: many files with same fields

navaneeth79 — Thu, 08 Feb 2018 08:45:35 GMT

I cant send the exact code but I will send the sample code:

let say my files are ABC_02022018.xlsx and ABC_05022018.xlsx

my code is

Test:

Load

if(D<100,1,0) as E

from

[$(vG.Path)\folder\ABC_*.xlsx]
(ooxml, embedded labels, table is Sheet1)

Re: many files with same fields

big_dreams — Thu, 08 Feb 2018 10:05:27 GMT

This must work..

do you have same data in both files????

Take one field in list box & check its frequency.

Regards,

Re: many files with same fields

navaneeth79 — Thu, 08 Feb 2018 11:31:53 GMT

similar data with dates changed, and if I remove drop table all the data from all files getting loaded but not getting stored in qvd

Re: many files with same fields

big_dreams — Thu, 08 Feb 2018 11:36:37 GMT

did you check data frequency??

If all data is same, then you will see double count of every value.

Regards,

Re: many files with same fields

navaneeth79 — Thu, 08 Feb 2018 11:37:56 GMT

data is unique data type is same

Re: many files with same fields

big_dreams — Thu, 08 Feb 2018 11:40:14 GMT

can you share screen shot?? Now it is difficult to guess with limited information..

Regards