I have multiple spreadsheets that are emailed to a specific address and stored to a file folder. All of these sheets will contain slightly different headers, however, every spreadsheet will at least have a common identification attribute.
Is there a way I can build a workbench to read through all of these excel files to search and extract this ID number from all excel files?
Thanks in advance for your suggestions!
Best answer by jeroen
Do you mind loading in all the data? This could do the trick for that extracting the test attribute from all Excel files in my temp location. You could tweak this to include subfolders or other file extensions. You could also add the Exposing attributes to the FeatureReader making the AttributeExposer obsolete.
+15Do you mind loading in all the data? This could do the trick for that extracting the test attribute from all Excel files in my temp location. You could tweak this to include subfolders or other file extensions. You could also add the Exposing attributes to the FeatureReader making the AttributeExposer obsolete.
Do you mind loading in all the data? This could do the trick for that extracting the test attribute from all Excel files in my temp location. You could tweak this to include subfolders or other file extensions. You could also add the Exposing attributes to the FeatureReader making the AttributeExposer obsolete.
