Auto Concatenation not working ?

[richard_chilvers]

Is there a situation when 2 identical tables don't concatenate?

I am building a table from external sources which allow only 100 records to be extracted at a time. So I am using a loop to extract batches of 100 at a time into a RESULTS table.

Of course each batch has identical fields, but I'm getting many tables called RESULTS-n, joined by a synthetic table.

Advice please on what is stopping me getting a single table?

[giakoum]

Can you please share the code?

Autoconcatenate works

[sunny_talwar]

Are you absolutely certain that the all of them have the same columns? May be an extra column get picked if you use LOAD *?

[richard_chilvers]

Hi Sunny

Since its just a loop in the script, I think the fields must be identical. This is what I get when I run the loop just one time:

!

[sunny_talwar]

Would you be able to share the loop part of the script?

[giakoum]

Most likely you are not specifying the table name so Qv assigns its own naming

[richard_chilvers]

As you see above, I am naming the table 'Responses'.

[richard_chilvers]

Hi Sunny

What are you thinking might be the issue? As you see passes 1 & 2 of the loop generate identical columns.

[giakoum]

Then it is either something in your code or QV version. What version are you using?

[swuehl]

You are not coping with multiple tables (like joining two tables) in a single loop run, are you?