TOPIC: mapping info from 2 different csv files

mapping info from 2 different csv files 5 years 7 months ago #2334

FlowHeater-Team
Topic Author
Offline
Posts: 340

Hi,

Is it possible to map or combine information from 2 different csv files in Flowheater?

One csv file contains inventory items with fields such as product id, upc, description, size etc., and another csv file containing fields such as quantity, price, product id for the same products.

I am trying to combine both information into one csv file so that the information for each item is matched up correctly.

Thanks
Ryan
Request received by email

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.

Please Log in or Create an account to join the conversation.

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: by FlowHeater-Team.

mapping info from 2 different csv files 5 years 7 months ago #2335

FlowHeater-Team
Topic Author
Offline
Posts: 340

Hi Ryan,

Yes, of course that´s possible

With the help of the String Replace Heater you can implement a CSV data lookup from a second CSV file , or even more. I’ve made a simple CSV lookup example for you, please have a look to the attachment csv-data-lookup.zip

File Attachment:

File Name: csv-data-lookup.zip
File Size:2 KB

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.

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: by FlowHeater-Team.