My biggest problem is taking these names with all different and some same information and consolidating them to one instance. I ended up just making new masters and copying and pasting to one massive spreadsheet.
I've made an example to demonstrate this. Please unzip the attachment and copy all FlowHeater EXE and DLL files into the same unzip folder. NOTE: If you do not copy the DLL and EXE files to this folder you have to change the paths in the batch-execute.cmd file.
Collecting all Information into one Excel file)
Open the collecting.fhd definition
Open the configurator for the READ side and select the excel file info-1.xls
Execute the definition
Repeat the steps 2 to 3 with all excel files (info-2.xls, info-3.xls, ...)
After all, the result is you have one Excel file "collecting.xls" with the consolidated information.
Sort and remove duplicate content)
The remove-duplicate.fhd definition firstly sorts the data from the Excel workbook "collecting.xls" by the fields "NR" and "Description". After sorting FlowHeater remove the duplicate content with the GroupBy Heater by using the same fields "NR" and "Description".
These steps above you can run automatically by executing the batch-execute.cmd script. Please have a look inside. For a description for the forefiles command, please have look to the example:
Import several CSV text files automatically
The same way you can collect other information on other places in the Excel worksheet; you just have to create one more FlowHeater definition.
Hope it's a bit clearer.
Attachment excel_collecting.zip not found
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.