I have two Excel reports generated on the same testing equipment; ‘ANALYSIS REPORT’ and ‘COMPARISON REPORT’. I have set up an Excel reader component and the report title occurs in different columns:
I know I must use a filter of some kind or perhaps a custom filter to identify which report I need to send to a particular pipe but I am unsure how to script this. There will only be two pipes which will eventually break down the reports into sections. Presently I have created one just for the COMPARISON REPORT but need the protocol to differentiate which report it is reading. The other pipe will be for the ANALYSIS report. Is there a script to identify the report titles? For instance, if 'ANALYSIS REPORT' exist then true, else false. If true the whole work sheet and all the data goes to pass and if false goes to fail