Import CSV files, map each file to one record
- FlowHeater-Team
-
Topic Author
- Offline
- Admin
-
- FlowHeater-Team
-
Topic Author
- Offline
- Admin
-
13 years 2 months ago #2161
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic Re:Import CSV files, map each file to one record
Hi Rick,
Of course
To do this you need one GroupBy Heater , one If-Then-Else Heater and one AutoID Heater .
The GroupBy Heater groups all records of each CSV file to one Record on the WRITE side. With the AutoID Heater and the If-Then-Else Heater you can decide which row from the READ would you like to store in which field on the WRITE.
I've made a little example to demonstrate how it´s work. Please have a look to the attachment.
With the help of the Batch Module you can run this Definition automatically and/or Import more than one CSV file at each time.
Example Batch Import Command
This command imports all CSV file are located in C:\Temp\
Of course
To do this you need one GroupBy Heater , one If-Then-Else Heater and one AutoID Heater .
The GroupBy Heater groups all records of each CSV file to one Record on the WRITE side. With the AutoID Heater and the If-Then-Else Heater you can decide which row from the READ would you like to store in which field on the WRITE.
I've made a little example to demonstrate how it´s work. Please have a look to the attachment.
With the help of the Batch Module you can run this Definition automatically and/or Import more than one CSV file at each time.
Example Batch Import Command
Code:
FHBatch.exe /ReadFileName C:\Temp\*.csv import-csv-files.fhd
Attachment csv_group_by_import.zip not found
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.
Attachments:
Please Log in or Create an account to join the conversation.
Time to create page: 0.258 seconds
