I have a project where the dispatcher will need to retrieve an .xlsx from an automated email. The email has an average of 150,000 rows of data, spread over 8 columns.
There is some filtering that needs to be done prior to uploading these items to Orchestrator. My question, is it more effective to:
- upload the entire file as a data table to Studio, then filter
- do some/all the filtering on excel file prior to uploading as a DT
Thanks in advance!