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

[#2]

a:

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



//Concatenate (Sheet)

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

DROP Table tmp_Sheet01;

DROP Table tmp_Sheet02;

[heimo_ernst_wei]

Thanks for your proposals

However it did not work.

What I get now is:

without concatenate statement:

Two tables one "Sheet" th other "tmp-Sheet02-1"

With concatement statement:

One table "Sheet" with five columns:

• Sheet.FileName
• Sheet.Title
• SHEETID
• tmp-Sheet02-1.FileName
• tmp-Sheet02-1.Title

The same applies using "ABCD" instead of "Sheet".

ABCD:

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



Concatenate (ABCD)



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



DROP Table tmp_Sheet01;

DROP Table tmp_Sheet02;

Result:

One table "ABCD" with five columns:

• ABCD.FileName
• ABCD.Title
• SHEETID
• tmp-Sheet02-1.FileName
• tmp-Sheet02-1.Title

[#4]

hi

try this

QUALIFY FileName,Title;

ABCD:

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

Concatenate (ABCD)

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



DROP Table tmp_Sheet01;

DROP Table tmp_Sheet02;

[Anonymous]

Looks like have QUALIFY statement before all that (?)

[#6]

Can you post your work file ?

[er_mohit]

try this

sorry something error in that dont put the * by mistake

qualify  FileName,Title;

ABCD:

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



Concatenate (ABCD)



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



DROP Table tmp_Sheet01;

DROP Table tmp_Sheet02;

Result:

One table "ABCD" with five columns:

• ABCD.FileName
• ABCD.Title
• SHEETID
• tmp-Sheet02-1.FileName
• tmp-Sheet02-1.Title

[Anonymous · Accepted solution]

"Qualify" is the likley reason of the problem.  The original script (the one in opening of the thread) should work if preceeded with

UNQUALIFY *;

[#9]

QUALIFY FileName,Title;

ABCD:

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

Concatenate (ABCD)

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



DROP Table tmp_Sheet01;

DROP Table tmp_Sheet02;

[heimo_ernst_wei]

What I have before is:

QUALIFY * ;
UNQUALIFY SHEETID;

Regards Heimo