Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
"Qualify" is the likley reason of the problem. The original script (the one in opening of the thread) should work if preceeded with
UNQUALIFY *;
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;
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:
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:
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;
Looks like have QUALIFY statement before all that (?)
Can you post your work file ?
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:
"Qualify" is the likley reason of the problem. The original script (the one in opening of the thread) should work if preceeded with
UNQUALIFY *;
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;
What I have before is:
QUALIFY * ;
UNQUALIFY SHEETID;
Regards Heimo