Crosstable issue

[Anonymous]

Hi ,

I have an issue, where i have date field with sales data for the day which is getting added daily in to the excel sheet. when i perform cross table load the the new date is not being reloaded. Again I have reload this task manually. please advice

Regards,

John

[petter]

Is the number of columns increasing for each day? Do you have a sample spreadsheet to share?

[petter]

If the number of rows is constant and the columns are dynamic you might be able to take advantage of the TRANSFORM / ROTATE / TRANSPOSE. But it is much easier to give advice if you have a sample of your source Excel. Or even just a description of the number of "dimension" fields.

[sunny_talwar]

I ran into a similar problem once and what I did was to bring in extra columns for 5 years worth of additions, in your case this may or may not work but you can give it a try.

Sunny

[Anonymous]

Hi Petter,

please find attached sheet.

Regards

John

[Anonymous]

Hi Petter,

Yes only the columns getting added no extra rows nothing

Regards

John

[sunny_talwar]

Modified your excel file. Please find attached the app and excel file.

HTH

Best,

Sunny

[Anonymous]

Sorry Sunny this is not what I'm looking for .....

[sunny_talwar]

Not a problem

I hope you can find your solution.

Best,

Sunny

[petter]

This Load Script code should do the trick for you:

LOAD Product as Day,
    P1,
    P2,
    P3,
    P4,
    P5,
    P6,
    P7
FROM
[..\Downloads\Sample (1).xlsx]
(ooxml, embedded labels, table is Sheet2, filters(
Transpose()
));