field names must be unique within table

[#1]

Hi,

I am trying to re create a qvd file as a new field has been added to an exisiting file.

In order for me to update the historical information I nned to recreate the qvd.

I am having trouble as I keep getting the following error:

Field names must be unique within table.

I am using preceding loads so I first load a temp table and then load from the temp table to a new table.

Is there a quick and easy way to re create a qvd file?

Regards,

Gregg

[#2]

Can you share the code you are using, this would make it a lot easier for people to understand what you are trying to do and where you might be going wrong.

[jagan]

Hi,

This error occur when you same name for more than one column.  Can you attach the script/file.

You can create qvd using

Store TableName into FileName.qvd;

Regards,

Jagan.

[#4]

If you need to load data from a lot of tables is advisable use the QUALIFY statement.

[#5 · Accepted solution]

Hi,

I got around the issue by simply removing the data from the qvd and reloading everything back in again with the new field.

My issue was with one filed name when I was concatenating.

Regards,

Gregg

[gauravkhare]

Hi Greg,

Gr8 that the issue is resolved.. Can you please send the sample script because the problem you've mentioned should not happen if we are taking distinct field names but yes while concatenating we need to give alias