Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create three new columns with just the drug name(Red), and two columns with the NDC(Green) numbers.
There is a variable char# count
Is this possible to do?
I have included an excel file with two different sets of data.
Reorder number and drug name are veritable character length.
LIB CONNECT TO 'pharmoresql production (pharmore_rwinkel)';
LOAD ID,
FacID,
PatID,
Msg,
UPPER (ChangedBy) as ChangedBy,
ChangedOn,
"Comment";
QL SELECT ID,
FacID,
PatID,
Msg,
ChangedBy,
ChangedOn,
"Comment"
ROM FwReports.dbo.PatientsLog
ere ChangedOn > '2015-1-1'
and Upper(Msg) like '% NDC FROM %';
please see above
PFA
I can't load, I use Qlik sense
Use the below to get the required columns
Load *,
TextBetween(Msg,'(',')') as Supplement,
SubField(SubField(Msg,'NDC from ',2),'"',2) as FromNDC,
TextBetween(SubField(SubField(Msg,'NDC from ',2),'to',2),'"','"') as ToNDC ;
LOAD PatID,
ChangedOn,
ChangedBy,
Msg,
Comment
From
Table;
Thank you vary much.
Do you know of a list of commands/expressions that Qlik uses?
Qlik manual is the best place to start with