Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
My script is loading all the tables from Excel it should, except of one:
[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
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.
Hi Miguel, thanks for the quick response.
Could it be something else? The noconcatenate is not working...
Thanks again.
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.
No error messages, nor crashing and no other table with the same fields.
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.