Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?