I have to develop a program to split 2 columns source into n columns of different attributes (last name, first name, etc.)
There is an Excel file at the input with 2 columns and an Excel file at the output with n columns.
I chose Talend to do this work with the tRegexField component that would allow me to split according to the split rules for each attribute.
Once this is done, I plan to save it as .jar and create a .bat file to run it.
The blocking point is that all this is for my client and he will have to modify the Excel input file as well. He doesn't have Talend and wouldn't want to install it.
What do you recommend to me to make it right, robust and autonomous?
The client should be able to either replace the file with same column either replace old lines by new. It's almost the same for me. The path must remain unchanged
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Read about some useful Context Variable ideas