Partial Reload in combination with Crosstable Load

birrdominik — Tue, 08 Oct 2024 09:46:20 GMT

Dear Community,

I am encountering an issue with a partial reload. I would like to perform a merge load on a previously loaded table. For this, I am pulling hourly values from a database and want to immediately perform a crosstable load, merging only the records that are affected by a unique key.

This is how my previously loaded Table looks like:

Key Date KpiKey ChangeDate Hour #Value

15241 20150101 4711 20190710160642 0 3

15241 20150101 4711 20190710160642 1 4

15241 20150101 4711 20190710160642 2 2

15241 20150101 4711 20190710160642 3 7

15241 20150101 4711 20190710160642 4 7

15242 20150101 4711 20190710160638 0 7

15242 20150101 4711 20190710160638 1 6

15242 20150101 4711 20190710160638 2 5

15242 20150101 4711 20190710160638 3 3

15242 20150101 4711 20190710160638 4 9

My Script looks like this:

Merge Only ("ChangeDate", LastChangeDate) on "Key","Date","KpiKey"

CrossTable(DayKey,#Value,5) LOAD

'Update' as Operation,

Key,

Date,

KpiKey,

ChangeDate

10,

11,

12,

13,

14,

15,

16,

17,

18,

19,

20,

21,

22,

23;

SELECT

Key

Date,

KpiKey,

ChangeDate

10,

11,

12,

13,

14,

15,

16,

17,

18,

19,

20,

21,

22,

FROM Database

Where Key=4711 and ChangeDate>$(LastChangeDate);

I get the following Error Message while performing a partial reload: "General Script Error in statement handling"

Can someone tell me how to fix that issue? Is it in general possible to perform a Merge Load with a Crosstable Statement?

Thanks in advance.

Best,

Dominik

Re: Partial Reload in combination with Crosstable Load

Qrishna — Thu, 14 Nov 2024 13:52:35 GMT

A late response but whats your expected output?

topic Re: Partial Reload in combination with Crosstable Load in App Development

Partial Reload in combination with Crosstable Load

Re: Partial Reload in combination with Crosstable Load