How to delete records from a specific LOAD_ID ?

Joe McHale

Hi all, on the old Birst forum I had published a guide on this! But that was years ago ..

Can anyone remind me how to delete records from a specific load_id ?

I know we can locate the LOAD_ID via the View Published data for a fact-table.. but need help in actually executing the delete

Thanks, Joe

Tamas Molnar

Hi Joe,

That is tricky, as the LOAd ID is mostly usable in Measurement table, and attributes doesn't have it.

I have tried it a lot of time, but you can experiment on a test space with LOAD_ID from measure table: grain([tablename]), and similar methods.

for structure, the data should be easily targetable by a date or deletion mark, that is the common knowledge, but of course it is coming late…