during script execution... <table name> -1

[#1]

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!

[#2 · Accepted solution]

Hi, I think, this means the number of columns, which were attached to the <table name> via JOIN

[jagan]

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.

[#4]

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!