Numeric to Text

Anonymous — Fri, 24 Feb 2012 11:22:53 GMT

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

Numeric to Text

m_woolf — Fri, 24 Feb 2012 11:57:23 GMT

Notes shouldn't have a comma

Numeric to Text

Anonymous — Fri, 24 Feb 2012 12:03:31 GMT

Wow, silly mistake.

Thanks

topic Numeric to Text in QlikView

Numeric to Text

Numeric to Text

Numeric to Text