Concatenate

[heimo_ernst_wei]

I have a problem which should be trivial but I did not find a solution. I try to add two (temporary) tables.

Sheet:

Load
SHEETID,
tmp_Sheet01.FileName as FileName,
tmp_Sheet01.Title as Title
Resident tmp_Sheet01;

DROP Table tmp_Sheet01;

//Concatenate (Sheet)

Load
SHEETID,
tmp_Sheet02.FileName as FileName,
tmp_Sheet02.Title as Title
Resident tmp_Sheet02;

DROP Table tmp_Sheet02;

The result is (with and without the "concatenate") that I have finally still two tables: "Sheet" and "Sheet-1"

Might looking stupid but I'm finding the error....

Thanks for any help

[Anonymous]

This is exactly the reason of your problem.  All your fields except SHEETID have different names, hence the table do not auto-concatnate.  And if you force to concatenate, they have different names in the resulting table.

[heimo_ernst_wei]

Qualify [tmp_Sheet01.FileName],[tmp_Sheet01.Title],[tmp_Sheet02.FileName],[tmp_Sheet02.Title];

Does not solve the problem.

Regards Heimo

[heimo_ernst_wei]

loding with "Load abcd AS xxxx" results in equal column names (xxxx) - at least I thought this.

[heimo_ernst_wei]

adding UNQUALIFY *;

This solved my problem!

Thanks!

UNQUALIFY *;

Sheet:

Load

SHEETID,

[tmp_Sheet01.FileName] as FileName,

[tmp_Sheet01.Title] as Title,

[tmp_Sheet01.%Key_DocumentSummary_3E3ED09C8BC69525]

Resident tmp_Sheet01;



Concatenate (Sheet)



Load

SHEETID,

[tmp_Sheet02.FileName] as FileName,

[tmp_Sheet02.Title] as Title,

[tmp_Sheet02.%Key_DocumentSummary_3E3ED09C8BC69525]

Resident tmp_Sheet02;



DROP Table tmp_Sheet01;

DROP Table tmp_Sheet02;

[Anonymous]

That means that the ABCD was auto-concatenated to a previous table which was later dropped.

Use NOCONCATENATE when loading ABCD.

ABCD:

NOCONCATENATE

LOAD

...

CONCATENATE (ABCD) LOAD

....