Copy data from one field to another field

[#1]

Hi,

I have a Oracle database for showing the Incidents data. The columns are Country, Company and many more. I need to show a graph as Region wise. The regions are North, South Europe, Americas, APAC. I mapped this with Regions excel as per the attachment using Country Column. But for some incidents Country column is blank. So while loading the data if the Country column is blank, then the value in Company should be filled in Country. I am using the following command, but Country is showing 0 after loading. Please assist.

LOAD incidenttype123,

     OpCategorizationTier1123,

     SupportGroup123,

      If(IsNull(Country123),Company,Country123) as Country123,

     ["Fact Ticket"."Incident Number"],

     ["Fact Ticket"."Customer Organization Technical Id"],

     ["Fact Ticket"."Reported Date"],

     ["Fact Ticket"."Submitter"],

     ["Fact Ticket"."Assignee"],

     ["Fact Ticket"."Last Resolved Date"],

     ["Fact Ticket"."Description"],

     ["Region"."ITSS"],

     ["SLM Status"."SLM Status"],

     ["Priority"."Priority"],

     ["Support Organization"."Support Company"],

     SupportOrganization123,

     ["Operational Category"."Operational Cat Tier2"],

     ["Operational Category"."Operational Cat Tier3"],

     ["Status"."Status"],

     ["Calendar Day"."Year Code"],

     ["Calendar Day"."Month"],

     ["Calendar Day"."Day Code"],

     ["Calendar Day"."Quarter"],

     custcomp,

     ["Impact"."Impact"],

     ["Fact Ticket"."Additional Info"],

     ["Fact Ticket"."Closed Date"],

     ["Fact Ticket"."Last Modified Date"],

     ["Fact Ticket"."Nb Group Transfers"],

FROM

;

Thanks,

Arun

[lironbaram]

hi

does the field company is one of the fields in the table ?

is so try

If(len(Country123)<2,Company,Country123) as Country123,

[#3]

Hi Lirom,

Thanks for the reply. After using the above statement in my load script, now I am able to see the values in Country123 column. But the Region is still showing blank.Please advise.

Thanks,

Arun

[lironbaram]

hi

did you map also the company field to regions

otherwise you want be able to add region for those records