topic Loading 4 files in same table in QlikView

Loading 4 files in same table

harleen_singh — Thu, 10 Mar 2011 12:48:40 GMT

Hello,

I am loading 4 files all having same number of columns and same name.

I want to load it in the same table say A:

when m doing partial reload it creates A1, A2, A3, A4 different tables. But i want it to load it on same table A: only.

Can anyone help me??

thanks

Lavi

Loading 4 files in same table

tresB — Thu, 10 Mar 2011 12:58:46 GMT

probably this is because, you are using partial reload. reload might solve your problem. if partial reload you need at utmost, you can try using "concatenate (Toptablename)" between tables.

regards, tresesco

Loading 4 files in same table

harleen_singh — Thu, 10 Mar 2011 14:19:55 GMT

Hello Tresesco,

yes reload is my problem. I have to do partial reload here.

Well i have tried Concatenate(A), Say if my table name is A.

but again it is creating two tables A and A1

I want it to create only A table and load all table values

thanks

Lavi

Loading 4 files in same table

Oleg_Troyansky — Thu, 10 Mar 2011 16:08:15 GMT

I strongly recommend getting rid of partial reload - it's an old rudiment, not very well supported. If partial reload is used to shorten the load time, you can transform it into a QVD load and still use a full reload.

just my 2 cents...

Loading 4 files in same table

harleen_singh — Thu, 10 Mar 2011 16:24:36 GMT

Oleg,

Thanks for ur suggestions about reload.

But my question is not answered. I don't have access to server for all reload i can do only partial Reload.

Is my problem can be solve through partial reload??

thanks

Lavi

Loading 4 files in same table

tresB — Thu, 10 Mar 2011 17:02:08 GMT

Hi,

mine is working ! probably you are missing ADD before CONCATENATE.

Regards, tresesco

Loading 4 files in same table

harleen_singh — Wed, 16 Mar 2011 09:54:27 GMT

tresesco,

I have used add obviously i cannot do partial load without that.

thanks

Lavi

Loading 4 files in same table

tresB — Wed, 16 Mar 2011 16:15:24 GMT

can you please post your script, or upload sample application? that could help us understand the possible issue.