Store Table & Column as columname in QVD

[johnan]

Hi community.

Is there possible to change the columns from DB when i Store to QVD?

I wan't the format [Table.Name]_Column saved to my QVD

Possible?

Br

John

[micheledenardi]

Try with Qualify statement.

LIB CONNECT TO 'SQLSERVER';
Qualify *;

LOAD 
    "COD_SITE",
    "DOC_MESE",
    "TMP_MESE",
    "COD_CDC_SAP";
SQL SELECT "COD_SITE",
    "DOC_MESE",
    "TMP_MESE",
    "COD_CDC_SAP"
FROM MES.PRESENZE;

And you table will be created with the table name added before the field name:

Than you have only to store your QVD as always..

[rubenmarin]

Hi, yes, you can use 'as' to rename field names.

LOAD
 BDFieldName1 as [TableName.QvdFieldName1],
 BDFieldName2 as [TableName.QvdFieldName2],
...

You can also the sentence Qualify *;, wich by dafult renames each field setting the QV table name before the field name