Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

chrisgoudy
New Contributor II

Numeric to Text

I'm having trouble getting the Client data to execute in the script. Here is the script I used, but when I reload it says there is an error

Client:

SQL SELECT

      [ProfileNo],

      [PatientName],

      [PatientTelNo],

      [ContactName],

      [ContactTelNo],

      [ContactCellNo],

      [ContactAddress1],

      [ContactAddress2],

      [ContactAddress3],

      [CallIncrementFlag],

      [InitialCallDate],

      [RamsNo],

      [Notes],

  FROM [CCP_Compliance].[dbo].[ex_ProfileMaster];

**************the entire script reads

Pharmacy:

SQL SELECT

     [ramsno],

     [PharmacyName]

  FROM [CCP_Compliance].[dbo].[ref_Pharmacies];

Client:

SQL SELECT

      [ProfileNo],

      [PatientName],

      [PatientTelNo],

      [ContactName],

      [ContactTelNo],

      [ContactCellNo],

      [ContactAddress1],

      [ContactAddress2],

      [ContactAddress3],

      [CallIncrementFlag],

      [InitialCallDate],

      [RamsNo],

      [Notes],

  FROM [CCP_Compliance].[dbo].[ex_ProfileMaster];

LOAD agentcode,

     agentname,

     callduration,

     callid,

     id,

     profileno as Client,

     ramsno as 'Pharmacy Name',

     statedescription,

     timestamp

FROM

C:\Users\chrisg\Documents\CallLogs.qvd

(qvd);

2 Replies
mwoolf
Honored Contributor II

Numeric to Text

Notes shouldn't have a comma

chrisgoudy
New Contributor II

Numeric to Text

Wow, silly mistake.

Thanks