topic during script execution... <table name> -1 in QlikView

during script execution... -1
Tue, 08 Oct 2013 02:53:26 GMT
Hello. I apologize because this is likely a painfully obvious question, but it's not very Google-friendly. While my script is executing, I frequently see:
<table name> << 123,456 records
<table name> -1 << 123,456 records
What does the "-1" indicator in the table name mean? I've tried stopping execution at various intermediate steps, but I can never get to see this "minus one" table.
Thanks!

Re: during script execution...

-1
Tue, 08 Oct 2013 03:13:03 GMT
Hi, I think, this means the number of columns, which were attached to the <table name> via JOIN

Re: during script execution...

-1
jagan — Tue, 08 Oct 2013 03:34:59 GMT
Hi,
Please check whether you are given the same table name for more than one table. When I tried below script it is reproducing the same issue

[table name]:
LOAD * INLINE [
Test
1
2
3
];

[table name]:
LOAD * INLINE [
Test1
1
2
3
];

If this not helps you, can you post the script which you are using, it helps in analysing the problem.
Regards,
Jagan.

Re: during script execution...

-1
Tue, 08 Oct 2013 18:02:46 GMT
Hi,
That seems to make sense. I'm doing a left join on two tables with previously-qualified field names and a single, UNqualified lookup field, so it makes sense that the previous table is receiving <column count> - 1 new fields.
Thanks!