Unqualify Stored Qvd Fields

[mpressey]

Is it possible to Unqualify  fields from a stored qvd that contains previously Qualified fields?

[oknotsen]

You will have to manually rename all the fields on load.

I would suggest doing the renaming on STOREing the QVD instead though.

[Anonymous]

Rename the Fields .

[avinashelite]

I suggest you to handle this while generating the QVD ....we don't have the direct way to rename or to change the column name of Qualified field you need to do it manually using the alias or rename or as keywords

[marcus_sommer]

Not tested yet but the logic should work:

YourQVDLoad:

load * From YourQVDLoad.qvd (qvd);

for i = 1 to nooffields('YourQVDLoad')

     FieldNames:

     load

          fieldname($(i),  'YourQVDLoad') as OldFieldName,

          subfield(fieldname($(i),  'YourQVDLoad'), '.', 2) as NewFieldname

     autogenerate 1;

next

MapFieldNames:

mapping load * resident FieldNames;

rename fields using MapFieldNames;

drop tables FieldNames;

- Marcus