Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD
GEO&'.'&[Operating Area]&'.'&[Sales_Region]&'.'&Territory&'|'&upper(ACCOUNT_SEGMENT)&'|'&[NCV_Type]&'.'&[Hyperion Budget Unit]&'.'&SCBU&'|'&left(Fiscal_Period,4)&'-Q'&Right(Fiscal_Period,1)
as [~MasterKey],
Pipe,
'PNCV' AS [NCV_Type]
FROm
(ooxml, embedded labels, table is Data);
this is the code , but the fiscal period is in the image below,
Load
...
Left(Fiscal_Period, 4) as fiscal_year,
Right(Fiscal_Period, 1) as Fiscal_Quarter,
....
Load
...
Left(Fiscal_Period, 4) as fiscal_year,
Right(Fiscal_Period, 1) as Fiscal_Quarter,
....
You can split it like this in the script:
Left(Fiscal_Period, 4) as FiscalYear,
Right(Fiscal_Period, 1) as FiscalQuarter
try like this:
LOAD
subfield(Fiscal_period,' ',1) as Fiscal_Year,
'Q'&subfield(Fiscal_period,' ',2) as Fiscal_Quater
from
table ;
I assume that you want 'Q' in fiscal quarter, so
'Q' & right(Fiscal_Period, 1) as Fiscal_Quarter,
My answer was even correct ...