Field names must be unique within table

[srikanth1994]

The following error occurred:

Field names must be unique within table

The error occurred here:

FINAL: Load *, IF((CONNECTION_TYPE_A_END ='Off-Net' or CONNECTION_TYPE_B_END='Off-Net'),'Offnet', IF((CONNECTION_TYPE_A_END='Near-Net' or CONNECTION_TYPE_B_END='Near-Net'),'Nearnet','Onnet')) as D_Connectivity, IF((isnull(CONTRACT_TERM_IN_MONTHS) or CONTRACT_TERM_IN_MONTHS = ''),'NA', IF(CONTRACT_TERM_IN_MONTHS<12,'<1Yrs', IF(CONTRACT_TERM_IN_MONTHS>=12 And CONTRACT_TERM_IN_MONTHS<24, '1Yrs < 2Yrs', IF(CONTRACT_TERM_IN_MONTHS>=24 And CONTRACT_TERM_IN_MONTHS<36, '2Yrs < 3Yrs', IF(CONTRACT_TERM_IN_MONTHS>=36 And CONTRACT_TERM_IN_MONTHS<48, '3Yrs < 4Yrs', IF(CONTRACT_TERM_IN_MONTHS>=48 And CONTRACT_TERM_IN_MONTHS<60, '4Yrs < 5Yrs', IF(CONTRACT_TERM_IN_MONTHS>=60 And CONTRACT_TERM_IN_MONTHS<72, '5Yrs < 6Yrs', IF(CONTRACT_TERM_IN_MONTHS>=72 And CONTRACT_TERM_IN_MONTHS<84, '6Yrs < 7Yrs', IF(CONTRACT_TERM_IN_MONTHS>=84 And CONTRACT_TERM_IN_MONTHS<96, '7Yrs < 8Yrs', IF(CONTRACT_TERM_IN_MONTHS>=96 And CONTRACT_TERM_IN_MONTHS<108, '8Yrs < 9Yrs', IF(CONTRACT_TERM_IN_MONTHS>=108 And CONTRACT_TERM_IN_MONTHS<120, '9Yrs < 10Yrs', IF(CONTRACT_TERM_IN_MONTHS>=120 , '+ 10Yrs')))))))))))) as 'TERM (YEAR)', IF(wildMatch(upper(BANDWIDTH),'','?','GigE','2000Kbps','E3 34M','SELECT','NULL') or isnull(BANDWIDTH),'Others', IF(wildMatch(upper(BANDWIDTH),'10000Mbps'),'>=01GB-<10GB', if((IF(WildMatch(upper(BANDWIDTH),'*MBPS*'),replace(upper(BANDWIDTH),'MBPS','')))<100,'>=01MB-<100MB', if((IF(WildMatch(upper(BANDWIDTH),'*MBPS*'),replace(upper(BANDWIDTH),'MBPS','')))>100,'>=100MB-<01GB', if((IF(WildMatch(upper(BANDWIDTH),'*GBPS*'),replace(upper(BANDWIDTH),'GBPS','')))<10,'>=01GB-<10GB', if((IF(WildMatch(upper(BANDWIDTH),'*GBPS*'),replace(upper(BANDWIDTH),'GBPS','')))<100,'>=10GB-<100GB', IF(wildMatch(upper(BANDWIDTH),'100 Mbps','200 Mpbs'),'>=100MB-<01GB', IF(wildMatch(upper(BANDWIDTH),'10M/10M1:1','25M/4M1:1'),'>=01MB-<100MB', '>=100GB' )))))))) as BANDWIDTH_CLASSIFICATION, OPPORTUNITY_ID & QUOTE_ID & QUOTE_LINE_ITEM_ID AS "MAPPING"

[lironbaram · Accepted solution]

it is a simple error. It means one of the fields you define has a similar name to one of the fields already part of the table. All fields in one table must have a unique name 

[srikanth1994]

But there is no matching filed names within the table still i am getting the error.

[Or · Accepted solution]

There's no way we can see if there are matching field names or not, since you're loading * from another table... presumably, one of the new fields you're adding has a name identical to something in that previous load.