Field names must be unique within table

[Ram9392]

Hi I am facing the below error.

Field names must be unique within table:

Left Join (RISKS)

Tabl1:

Load *,

If(IsNull ([Location]), 'NO', 'Seng' ) as ,

If([ Level 2] = ' Banking' and
[ Level 3] = ' Wealth' and
[ Level 2] <> ' Limited' and
not WildMatch([ Level 3], ' Corporation', ' Raharja',
' Company Limited',
' Bank Company Limited',
'BC Rural Bank Company Limited'), 'RBWM', 'NO' ) AS [Is RBWM],

IF( ([Business Level 2] = 'Personal Banking' AND
[Business Level 3] <> 'Banking and Wealth' and
[Business Level 3] <> 'PT Bank ' AND
[Business Level 3] <> 'Finance Corporation' AND
[Business Level 3] <> 'Rural Bank Company Limited' AND
([Business Level 2] <> 'Bank Limited' AND not WildMatch
([Business Level 3], 'Insurance*') AND
[Location Level 2] = 'States') //, 'RBWMUS' Need to check this.....
and
IF ([Location Level 2] = ' UK' AND
match ( Level 3], 'Retail and Wealth'), 'ABC', 'NA' ) ), 'NA' ) AS [Packs]

Resident Tabl1;

Like that I have so many Flags, 

Please help on this error

[Aurelien_Martinez]

Hi,

First a field name is missing at :

If(IsNull ([Location]), 'NO', 'Seng' ) as ,

Second, can you share all the column loaded in the table Tabl1. Because you are using * in your load, and we can see all the field.

Or do you have Packs and Is RBWM in the first table ?