qualify and concatenation issue

[#1]

Hi guys,

I am concatenating few tables which are loaded from QVD files.

I am using QUALIFY * statement so prefix the column name to the concatenated table name but i see a strange behavior that only first table's column  is getting qualified with concatenated table name and rest of the table'column are qualified by original QVD file name.

QUALIFY *;

UNQUALIFY TxnID;

[Sales]:

Load

TxnID as S.TxnID,

Amount

from

invoice.qvd;

Concatenate(Sales)

Load TxnID as S.TxnID,

Amount

from

SalesOrder.qvd;

Here is the list of columns

TxnID (expected S.TxnID)

Sales.Amount

SalesOrder.Amount (not expected)

What am I doing wrong here?

[#2]

This code will give me fields like

Sales.Amount

Table1.Amount

right?

if then it will not work for me becasue I need to have only one field

i.e. Sales.Amount

[tresesco]

Rightly pointed out.

Try:

Concatenate(Sales_T)

or, simple remove that line. Having all fields similar it will get auto concatenated.

[#4]

Thanks, It works.

[#5]

Rename your Sales Amount to Amount and qualify it. Then there will only be one