3 Replies Latest reply: Oct 27, 2010 6:06 PM by John Witherspoon RSS

    Qlikview script forgetting table names

    bryankoch

      Here's the script in question:

       

      [Cardiology]:
      LOAD @1, @1 as Taxonomy, text(purgechar(trim(@2),'.')) as Diag1, text(purgechar(trim(@3),'.')) as Diag2, text(purgechar(trim(@4),'.')) as Diag3, text(purgechar(trim(@5),'.')) as Diag4
      FROM C:\Users\kkorynta\Desktop\Cardiology_and_Gastroenterology_Diagnosis_Mix.txt (txt, codepage is 1252, no labels, delimiter is '@', msq);

      [TaxonomyReference]:
      LOAD TAXONOMY_PK as [Taxonomy], [TAXONOMY FIELD] as [Taxonomy Category]
      FROM [C:\Users\kkorynta\Documents\Big Project\References\References!.xlsx] (ooxml, embedded labels, table is [Master Taxonomy]);

      [CardiologyPivot]:
      Crosstable ([I-9 CM Variable], [I-9 CM Code], 2)
      Load recno() as ID, [Taxonomy],
      Diag1,
      Diag2,
      Diag3,
      Diag4
      Resident Cardiology;

      [CleanCardiologyPivot]:
      Load ID, [I-9 CM Variable], [I-9 CM Code], Taxonomy Resident CardiologyPivot Where [I-9 CM Code] > 0;

      Left Join (CleanCardiologyPivot)
      Load [Taxonomy], [Taxonomy Category] Resident TaxonomyReference
      Where exists([Taxonomy]);

       

      This ran correctly for a bit, then on one of my reloads, the CleanCardiologyPivot is no longer recognized as a table. Is this a bug or am I doing something wrong?