1.Simply I’ll summarize the steps of the script as follows:
Read the XLS file DailyReport_expt.XLS (33 KB)
and extract the data.
2.Build an internal data table for the drug name along with its medication code and either it is a scar medication or a meta medication.
3.organize the XLS file data using the data in the med codes datatable to produce set of data and store it in a final dataTable:
please find the attached .xaml for the solution to this file
medcodesDT (1).xaml (38.4 KB)