Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Excel to Excel

Excel to Excel 6 years 1 month ago #2044

  • Renee
  • Renee's Avatar
  • Offline
  • New Member
  • Posts: 3
How do I take alot of small excel spreadsheets and make one spreadsheet without duplicates but keeping any additional information that another excel sheet would have.
The administrator has disabled public write access.

Re:Excel to Excel 6 years 1 month ago #2045

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
You have to use a little trick. Follow these steps below.
  1. Create a new definition to export all data into a new excel workbook.
  2. Append (manually) all excel spreadsheet to this excel workbook by using the little trick see the forum post "Excel append records"
  3. Create another definition select the excel workbook you have created above.
  4. Move the Sort Heater into the definition and connect the certain field where contains the duplicate information to the Sort heater.
  5. Move the GroupBy Heater into the definition and connect the same field to the GroupBy Heater. This removes duplicate records on the WRITE side.

NOTE: You can automate step 2 by using the FHBatch module. Have a look to the Example: "How to import several CSV text files automatically to an Access database".
Best wishes
Robert Stark

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.
Last Edit: 1 year 10 months ago by FlowHeater-Team.
The administrator has disabled public write access.

Re:Excel to Excel 6 years 1 month ago #2049

  • Renee
  • Renee's Avatar
  • Offline
  • New Member
  • Posts: 3
I am having trouble with this. does it work for spreadsheets with names and addresses?
The administrator has disabled public write access.

Re:Excel to Excel 6 years 1 month ago #2051

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
We could make an example for you, what is your problem? Sorting and grouping to filter the duplicate rows/records or appending all your small excel spreadsheets first to one big excel workbook?

Please give as a bit more information, thanks.
Best wishes
Robert Stark

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.
The administrator has disabled public write access.

Re:Excel to Excel 6 years 1 month ago #2054

  • Renee
  • Renee's Avatar
  • Offline
  • New Member
  • Posts: 3
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.
The administrator has disabled public write access.

Re:Excel to Excel 6 years 1 month ago #2055

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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)
  1. Open the collecting.fhd definition
  2. Open the configurator for the READ side and select the excel file info-1.xls
  3. Execute the definition
  4. 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".


Automatically executing)
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

Attachments:
Best wishes
Robert Stark

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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.081 seconds