topic Load table not working in QlikView

Load table not working

Fri, 18 Mar 2011 13:29:17 GMT

My script is loading all the tables from Excel it should, except of one:

LOAD

[Group Company]

[Exco Area]

FROM

biff, embedded labels, table is

[Master Data$]);

I've tested this part of the script in a separate and empty QlickView document and there it creates the table.

Does anybody have an idea why it works in one QV document but not in the other one?

Thanks a lot!

Belen

Load table not working

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 13:38:13 GMT

Hello Belen,

It is possible that this table is being concatenated implicitly with a preivously loaded table having two fields named alike. The ampty document doesn't have any tables, so it loads.

If your document has already this table, will concatenate to the previous one. You can avoid this using NOCONCATENATE before the LOAD statement.

Hope that helps.

Load table not working

Fri, 18 Mar 2011 13:55:37 GMT

Hi Miguel, thanks for the quick response.

Could it be something else? The noconcatenate is not working...

Thanks again.

Load table not working

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 13:58:40 GMT

Hello Belen,

Is QlikView throwing some error or crashing? Or it's just that you cannot see the records? Is there any other table with those two fields?

Regards.

Load table not working

Fri, 18 Mar 2011 14:04:59 GMT

No error messages, nor crashing and no other table with the same fields.

Load table not working

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 16:28:53 GMT

Hello,

I keep thinking of implicit concatenation, anyway, label that table, rename fields, do a debug reload in the script editor and take a closer look (if you didn't already) at what happens when QlikView executes that load part, and keep us posted.

Regards.