Partial Reload in combination with Crosstable Load
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
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23;
SELECT
Key
Date,
KpiKey,
ChangeDate
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23
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?
