2 Replies Latest reply: Aug 8, 2012 1:52 AM by At titude RSS

    Needing assistance with modifying the load

      I’m not sure how to modify the load script in Qlikview and I was told that to group dates by month, I have to add Month(Date) to the load script. I loaded in two files and I need the Chg Service Date to show as a month on both files. Can anyone provide assistance?

       

      LOAD [Chg Tx ID],

           [Patient Name],

           MRN,

           [Unique MRNs],

           [MRN + Month+FY],

           [Unique MRN/Month],

           DOB,

           [Chg Service Date],

           FY,

           [MRN/FY],

           [Unique MRN/FY],

           Month,

           [Month/Type/FY],

           [Chg Post Date],

           [Current Payor Name],

           [Current Plan Name],

           Type,

           Department,

           Specialty,

           [POS Type],

           POS,

           [Guarantor Name],

           [Patient Country],

           [Patient Country Name],

           CPT,

           [CPT Desc],

           Vol,

           [Chg Amt],

           Pmts,

           [Projected Pmts],

           [Total Adj],

           [Bal Due]

      FROM

      [C:\Users\murphyc2\Desktop\PB Charges_FY12_FY13July.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      LOAD [Hospital  Account ID],

           [Patient Name],

           [Admission Date],

           [Discharge Date],

           [Length of Stay(LOS)],

           [Patient Mrn],

           [Primary Payor Name],

           [Current Plan Name],

           [Chg Service Date],

           FY,

           [Tx Post Date],

           [Procedure Code (CPT/HPCS)],

           [Procedure Desc],

           [Transaction Quantity],

           [Chg Amt],

           Trans_Base_Class,

           [Ub Rev Code ID],

           [Patient Country Name]

      FROM

      [C:\Users\murphyc2\Desktop\HB Charges_FY12_FY13.xlsx]

      (ooxml, embedded labels, table is Sheet1);