Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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...
Thank you very much