Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am getting stuck here that how to upload or fetch latest new target excel file with fashion of old 17-18 excel file.
In Target 17-18 file have multiple (12 times) record for HQ_NAME in TargetDate as vertical and [TAR Val AMT] amount have addition of 12 months target .
Now kindly suggest how to extract new file (target 18-19) to existing application.
Thanks
PFA for sample file.
Like this:
T1:
CrossTable(TargetDate, [TAR Val AMT], 3)
LOAD *
FROM
(ooxml, embedded labels, table is Sheet1);
//*Fix Date Format
T2:
NoConcatenate
LOAD [SG ID],
[HQ ID] as HQ_ID,
HQ_NAME,
Date(Trim(TargetDate)) as TargetDate,
[TAR Val AMT]
Resident T1;
DROP Table T1;
Concatenate(T2)
LOAD [SG ID],
HQ_ID,
HQ_NAME,
[TAR Val AMT],
Date(TargetDate) as TargetDate,
[Monthly Tar Val]
FROM
(ooxml, embedded labels, table is Sheet1);
PFA