Displaying 2 results from an estimated 2 matches for "res_seqno".
Did you mean:
new_seqno
2010 Mar 15
1
inner join sqldf
...;")
test_sql_innerjoin <- sqldf("select * test_sql_psd inner join test_sql_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_c...
2010 Mar 12
7
sqldf not joining all the fields
...ck.names = TRUE,fill=TRUE,
strip.white = TRUE, blank.lines.skip = TRUE,
comment.char = "#", allowEscapes = FALSE, flush = FALSE,
fileEncoding = "", encoding = "unknown")
x_data
prochi prescribed_date dataMonth item_code res_seqno quantity directions
CAO0000713 22/06/2001 NULL 842752 NULL 60 1/D
CAO0000713 28/04/2000 NULL 7800 NULL 100G A/TD
CAO0000713 10/04/2000 NULL 842652 NULL 60 1/D
CAO0000713 03/07/2000 NULL 842652...