Hi,
Can you please help…
i need to do a flow in rpa that will
- take a csv file (columns "customer_No, status,product,date_ordered, category,Main_representative, Assistant_representative)
) from a folder D:\rpa\sales\customer_detail.csv - load full file in one main data table
- filter by the column category code (8001, 8002) to move data in 1 data table dt_category_high and get the representative code from the customer.csv and lookup in the email csv to send mail to the corresponding representatives
- filter by the category (8010) to a data table dt_category_low and send mail to a specific mailgroup cc the main rep. & assistant rep
