Displaying 2 results from an estimated 2 matches for "no_of_packs".
2010 Mar 15
1
inner join sqldf
...ql_tsf
on test_sql_psd.prochi=test_sql_tsf.prochi")
colnames(test_sql_psd)
[1] "prochi" "prescribed_date" "dataMonth" "item_code"
[5] "res_seqno" "quantity" "directions" "no_of_packs"
[9] "datasource" "scan_ref_no" "name"
"approved_name"
[13] "formulation_code" "strength" "measure_code" "bnf_code"
[17] "bnf_description"
colnames(t...
2010 Mar 12
7
sqldf not joining all the fields
...8/2001 NULL 842752 NULL 60
1/D
8 CAO0000713 17/09/1993 NULL 39620 NULL 5ML
NIL
9 CAO0000713 01/05/2001 NULL 842752 NULL 60
1/D
10 CAO0000713 05/03/2001 NULL 842752 NULL 60
1/D
no_of_packs datasource scan_ref_no name formulation_code strength
1 NULL TSF NULL <NA> <NA> <NA>
2 NULL TSF NULL BETNOVATE RD OINT 0.025%
3 NULL TSF NULL <NA>...