A stand-alone Talend program

Four Stars

A stand-alone Talend program

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?

 

Community Manager

Re: A stand-alone Talend program

How and what the client will modify the Excel input file? Just change the file path or add or remove columns or change the column order?

----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: A stand-alone Talend program

Hi,

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog