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
You can define the file path with a context variable, set a default value to context variable. It enables you to pass a new file path value to context variable when you execute the .bat file out of Talend Studio.
