Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

(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);

1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Re: Needing assistance with modifying the load

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

2 Replies
jason_michaelid
Honored Contributor II

Re: Needing assistance with modifying the load

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

Not applicable

Re: Needing assistance with modifying the load

Please do as suggested by jason it will workout!

Community Browser