topic Re: How do I get user input from the keyboard in talend in Talend Studio

How do I get user input from the keyboard in talend

chichibio — Sat, 16 Nov 2024 08:32:58 GMT

Hi guys,

I would insert an input date from keyboard, store in context var the value and

pass that var in mysql query like that:

context.var prompt like string

tjava component -> TalendDate.parseDate("yyyy-MM-dd",context.var)

tmysql component -> select * from table where date(columns) > "'+context.var+"'

thnx at all

vboppudi — Thu, 15 Mar 2018 17:39:42 GMT

Hi,

While creating context variable please select default box, then it will prompt for value when you run job.

Regards,

chichibio — Fri, 16 Mar 2018 09:14:08 GMT

Hi Veeranjaneyulu Boppudi,

thnx a lot for your description.

Very accurate!!

I'm do it and works well!

regards,

Davide

chichibio — Fri, 16 Mar 2018 09:36:21 GMT

Hi Veeranjaneyulu Boppudi,

just the last question:

I would export the job to run file .bat. But, I need insert the input (like message box) to make a query.

There's any solution to do it?

thnx

Dav