Crosstable (memory use)

Fri, 08 Mar 2013 15:24:41 GMT

Hello All,

I need to consolidate fields and see that using a crosstable is the best way to do that. Below is my script. I don't think I am making this load as efficient as possible and my guess is bc I am using a resident load with each crosstable? (although that is what I need sourced). If you look at the first crosstable I want the options for the end users to have a PRIN DIAG field (prev loaded), a SEC DIAG field (prev loaded), and then a DIAGNOSIS field which is combo of both. To load my script pre-crosstable it used about 4 gigs of ram. When I added the 3 crosstables I killed it after it had consumed close to 9 gigs of ram. Just wondering if someone can verify I am using the best practice? Attached is the full script (crosstables are pg. 4-5).

Thank you,

CrossTable (ALLDIAG, DIAGNOISIS,2)
LOAD
[PRIN DIAG],
[SEC DIAG & NAME]
Resident FINAL_DATA_1;

CrossTable (ALLPROC, PROCEDURE, 3)
LOAD
[PRIN PROC],
[SEC PROC ICD9 & NAME],
[SEC PROC HCPC & NAME]
Resident FINAL_DATA_1;

CrossTable (ALLPHYS, PHYSICIAN, 4)
LOAD
ATTENDING,
ADMITTING,
REFERRING,
SURGEON
Resident FINAL_DATA_1;

Drop table FINAL_DATA_1;

topic Crosstable (memory use) in QlikView

Crosstable (memory use)