topic Specify the table name in QlikView

Specify the table name

Wed, 17 Mar 2010 11:15:16 GMT

Morning all,

Can I specify the table name in the import script? I'm thinking particularly when I am concatenating from two sources eg:


select * from SourceA
concatenate
select * from SourceB

and I want to see the table as CombinedTable.

Any ideas?

Thanks,

Tony

Specify the table name

prieper — Wed, 17 Mar 2010 11:36:16 GMT

The concatenated file will inherit the name of the first file, thus your script may read:

CombinedFile:
select * from SourceA;
concatenate (CombinedFile) select * from SourceB;

It is not necessary in this example to specify, to which file the "B" should be added, but it makes script a bit clearer and prevents error, if you shuffle the code around.

HTH
Peter

Specify the table name

Wed, 17 Mar 2010 14:41:46 GMT

Cracking! Thanks v much Peter,

Tony