topic Re: How to insert a field to distinguish a select in QlikView

How to insert a field to distinguish a select

Wed, 23 Jan 2013 17:34:08 GMT

Hi ,

I have this script which stacks six loads into only one (they all have the same columns) whithout distinguish among them.

ODBC CONNECT32 TO [dBASE Files];

SQL SELECT *

FROM `Y:\EMP83`\diario;

SQL SELECT *

FROM `Y:\EMP84`\diario;

SQL SELECT *

FROM `Y:\EMPD2`\diario;

SQL SELECT *

FROM `Y:\EMPD3`\diario;

SQL SELECT *

FROM `Y:\EMPY1`\diario;

SQL SELECT *

FROM `Y:\EMPY2`\diario;

How could I join an extra field called 'name' to write in it 'EMP83' for first select rows, ' EMP84' for second select rows... and so on?

Thanks

Gysbert_Wassenaar — Wed, 23 Jan 2013 17:41:52 GMT

Add a literal string as value for the name field:

SQL SELECT *, 'EMP83' as name

FROM `Y:\EMP83`\diario;

SQL SELECT *, 'EMP84' as name

FROM `Y:\EMP84`\diario;

etc...

Wed, 23 Jan 2013 17:52:23 GMT

Thank you very much