Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you please share the code?
Autoconcatenate works
Are you absolutely certain that the all of them have the same columns? May be an extra column get picked if you use LOAD *?
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:
!
Would you be able to share the loop part of the script?
Most likely you are not specifying the table name so Qv assigns its own naming
As you see above, I am naming the table 'Responses'.
Hi Sunny
What are you thinking might be the issue? As you see passes 1 & 2 of the loop generate identical columns.
Then it is either something in your code or QV version. What version are you using?
You are not coping with multiple tables (like joining two tables) in a single loop run, are you?