I am new to R and I am wondering is it possible to do the following (see code below). I keep getting an error. My goal is to read in the xlsx file and then left join the query based on the name of the agent.
Also an issue. For some reason in the xlsx file, the names are stored as numbers. How do I fix this?
agent_scores <- read.xlsx("~/janeka/Agent Scorecard/agent_kpi_report_All CS_All_2020-01-01_2020-01-31.xlsx")
agent_qa <- qry("select *
from qadash_production" )
scorecard <- left_join(agent_scores,agent_qa,by="Agent.Name")