Excel files Upload

[prma7799]

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.

[jonathandienst]

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);

[prma7799]

PFA