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
