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
Use Workbook activities read the data and use filtering in Studio
If you used excel activities you will end up with high time(If the data is 8 lakh plus then filtering on excel and using might make sense or use excel as database and use query where filtering is also done using where clause)