• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Setting a Context Variable from a Single Cell in Excel

#1 2012-05-31 19:44:48

andybrown
Member
Registered: 2008-05-20
Posts: 107

Setting a Context Variable from a Single Cell in Excel

I have a context variable that I'd like to set using a value that is in one cell inside an Excel file. I have set up the tFileInputExcel component to choose the proper cell, but when I try to set the context variable with a tJava component, I keep getting null as the value.

While experimenting I just output the value from the tFileInputExcel to a tFileOutputText and it works just fine. I just can't access the value any other way.

I feel like this should be very simple to do.


Uploaded Images

Offline

#2 2012-06-01 04:31:48

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Setting a Context Variable from a Single Cell in Excel

Hi

Use tJavaRow instead of tJava.

Regards,
Pedro


Only Paranoid Survive.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Setting a Context Variable from a Single Cell in Excel

Board footer

Powered by FluxBB