Needing assistance with modifying the load

[#1]

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

(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

(ooxml, embedded labels, table is Sheet1);

[Jason_Michaelides · Accepted solution]

At a glance it seems both your data files are transaction-type data so you should look to concatemate them into a single table:

Fact:

Load

  'PB Charges' AS FactType,

  *,

Month(ChgDate) As ChargeMonth

From PB file...;

CONCATENATE (Fact)

Load

  'HB Charges' AS FactType,

  *,

Month(ChgDate) As ChargeMonth

From HB file...;

Hope this helps,

Jason

[#3]

Please do as suggested by jason it will workout!