I have the below script but it is throwing error - Can FirstSortedValue be included within partial reload ?
App reloads without any error but when I reload from the front end, writeback table (Vizlib) it shows 'Data model out of sync error'.
Writeback_Comments_Tmp: LOAD Distinct
"ID" &'-'& "Event Type" &'-'& date("Event Date") as Comments_IDKey,
FirstSortedValue(Comments,-num("CreatedAt_56ad3b3b8b024924aad736a339fa507b")) as CDR_Latest_Comments
FROM "Writeback Test.qvd" (qvd) group by "ID","Event Type","Event Date";
if IsPartialReload() then add only Concatenate (Writeback_Comments_Tmp)
"ID" &'-'& "Event Type" &'-'& date("Event Date") as Comments_IDKey,
FirstSortedValue(Comments,-num("CreatedAt_56ad3b3b8b024924aad736a339fa507b")) as CDR_Latest_Comments
FROM "Writeback Test.qvd" (qvd) group by "ID","Event Type","Event Date";
end if;
left join Writeback_Comments_Tmp: LOAD Distinct
"ID" &'-'& "Event Type" &'-'& date("Event Date") as Comments_IDKey, "ID" AS "CDR WB Lease Option ID" ,
"Event Type", date("Event Date") AS "Event Date",
Comments
CreatedBy_56ad3b3b8b024924aad736a339fa507b as "Created By", CreatedAt_56ad3b3b8b024924aad736a339fa507b as "Created Time", num("CreatedAt_56ad3b3b8b024924aad736a339fa507b") AS "Created Num"
