PQ not Appending tables correctly and creating a null column

[JeffGrant]

Hi all, I am looking for a suggestion on what can be wrong.

I have several sets of tables that I append using PQ. On the whole everything is fine, except for one set. Each set is made up of two tables only to give me a resultant table.

The source data is two tables.
The headings are the same (because they have been copied/pasted).
The Data structures are the same in the both tables. PQ determines the same data type in both tables.
So all looks good.

However, with this one query, there is one pair of columns that PQ does not want to recognise as being same, despite the headings being copied/pasted, and the data type being the same.

So what happens is this....

Where table 1 is appended to table 2 ie the last row of table 1, meets first row of table 2, the column headings are not recognised and so an extra "null" column is added to the resultant table.

It does not mater which way I join the tables, the result with the extra column is the same.

Any ideas would be greatly appreciated.

Jeff

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[JeffGrant]

Thanks for the quick reply Alan. I an aware that adding files can aid the solution, however, i am sure that you can appreciate it is not always possible to supply data, especially if the client says NO and cant reproduce dummy data either.

Hence the amount of detail i put in the post to see if anybody has some ideas.

[alansidman]

Jeff,
I understand your situation, but from my perspective, it is difficult to analyze issues without seeing the data. Hope someone else will be able to help, but I decline to take this further. Good Luck.

Alan

[JeffGrant]

Problem Solved.....

Note sure why the copy/paste column headers didn't work, buy I renamed the offending column with the single letter A, and the problem has been resolved.

thanks anyway Alan.

[AliGW]

I was going to say that you must have a column mismatch.

Please mark solved.

[JeffGrant]

oops - thanks Ali...forgot that part :-(