Field Name should be Unique with in the table

[#1]

Hi All,

I am facing problem on when reloding am getting error for cross table

like "Field Name should be unique with in the Table"

temp:

CrossTable(ProductA,Amount,11)

Load *

from

when i relode above it is giving above error like( "Field Name should be unique with in the Table")?

can you please tell me why it is coming.

Best Regards,

sanjeev

[manideep78]

Hi Sanjeev,

I think your excel has multiple fields with same name.Once check in the Excel file.

Please post you sample App and Sample data.

Regards,

Manideep

[Miguel_Angel_Baeyens]

Hi Sanjeev,

Either because you already have in your 11 previous fields that are not part of the cross table a field named ProductA or Amount, or because in the excel some columns are named alike, because you are using LOAD * instead of LOADing each field by its name.

Miguel

[Siva_Sankar]

There were two or more fields with same name. Try looking from the script editor, remove the field name which is repeating and remove it.

Regards,

siva

[sujeetsingh]

Mani ,

Is correct it may be the issue with it.

You can use created key as by using Autohash() functions in qlikview

[#6]

thanks for that i have changed it is working but when i use temp as resident for another then field not found <Scale name> error coming.can you please replay for taht??

[#7]

hanks for that i have changed it is working but when i use temp as resident for another then field not found <Scale name> error coming.can you please replay for taht??

[manideep78]

Post you Sample App and Sample Data.