Table loop

Fri, 23 Dec 2011 09:35:02 GMT

Hi,

I'd tried to import a list of txt-files. The numbers of documents is variable. After I execute this script, qlikview generate a lot of tables called "qlik_details", "qlik_details-1", "qlik_details-2" and so on. The problem is, that we need all the data in one table called "qlik_details".

I tried to handle this with "resident", but it does not work.

Any ideas?

Many thanks,

Hernandez

Sub DoDir (Root)

For Each Ext In 'txt'

For Each vFile In FileList (Root & '\*CPG_CLICK_DETAIL*.' & Ext)

qlik_details:

QUALIFY*;

Load

CAMPAGNE_ID,

MEMBER_ID,

CLIENT_ID,

SEGMENT,

SOURCE,

UPLOAD_ID

FROM $(vFile)

(txt, utf8,embedded labels,delimiter is ';', msq);

Next vFile

Next Ext

For Each Dir In DirList (Root & '\*') // Subfolders

Call DoDir (Dir)

Next Dir

End Sub

Call DoDir ('D:\Files\ClientFolder'); // Folder

UNQUALIFY*;

Table loop

forte — Fri, 23 Dec 2011 10:01:42 GMT

Hi Hernandez ,

You can't use qualifying in this context. You are changing the field's names on each loop, so Qlikview is not able to make the implicit concatenate (as you it's only done when both tables have the same number of fields and the same names for them).

Try to avoid qualify (and unqualify) sentence and it will work.

Hope it helps

Regards

Table loop

Fri, 23 Dec 2011 10:09:15 GMT

It works!

Thanks!

topic Table loop in QlikView

Table loop

Table loop

Table loop