Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The tables I loaded into qlikview show numeric values for clients and pharmacies.
How do I change the numeric values into the names of the clients and pharmacies?
Hi,
Use like this.
Pharmacy:
SQL SELECT
[ramsno],
[PharmacyName]
FROM [CCP_Compliance].[dbo].[ref_Pharmacies];
CallLog:
LOAD agentcode,
agentname,
callduration,
callid,
id,
profileno,
ramsno,
statedescription,
timestamp
FROM
C:\Users\chrisg\Documents\CallLogs.qvd
(qvd);
Qlikview has feature that it automatically joins the field which has common name.Here you don't need to join the two tables.
Celambarasan
Hi,
What is the relation between numeric values for clients,pharmacies and names of the clients ,pharmacies?
little more briefer please.
Celambarasan
I'm not exactly sure.
LOAD agentcode,
agentname,
callduration,
callid,
id,
profileno as Client,
ramsno as 'Pharmacy Name',
statedescription,
timestamp
FROM
C:\Users\chrisg\Documents\CallLogs.qvd
(qvd);
This is all the data in the script I have
Does that help anymore, or is there further info I can provide to make it easier to help out?
Hi,
Which table has Clientname and Pahrmacy name for its corresponding profileno and ramsno ?
Celambarasan
Sorry, I don't know. Do these tables possibly exist outside of my qlikview model?
Hi,
Check the database what all the tables related to the fields profileno and ramsno.
You need them to get the client name and pharmacy name.
if you don't the info then ask your client to provide that information.
Celambarasan
Hi,
Try this script and check whether any extra columns are fetched, if extra columns are fetched then look for the Client and Pharmacy name columns.
LOAD
*
FROM
C:\Users\chrisg\Documents\CallLogs.qvd
(qvd);
Hope this helps you.
Regards,
Jagan.
Ok, I see the table that lists ramsno with the corresponding pharmacy name
Here is the syntax of the script that appears when I select it
SELECT TOP 1000 [Ramsno]
,[PharmacyName]
FROM [CCP_Compliance].[dbo].[ref_Pharmacies]
Do I need to put this directly into the script, or do I need to load this table into the script?
Hi,
If you already made a connection to the database in script means then you can use this script directly.
Celambarasan
do I use the exact script besides:
Select Top 1000 ??
I'm not sure where in the script to put it either