• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » How to pass two values dynamically

#1 2009-02-28 06:34:18

e.jyothsna
Member
Registered: 2008-11-26
Posts: 34

How to pass two values dynamically

Hi

   My input is CSV file and one table and i connected to tmap.Output is another table.My question is i need to pass more than two parameters into one the field of my input table.I given like "row1.gender,row1.status and i selected inner join of my input table.But its not working.Any one can guide me on this?

Thanks
Jyothsna.E

Offline

#2 2009-03-02 04:40:38

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: How to pass two values dynamically

Hello

Using the 'iterate' link, I think your job should be like:

tFileInputCSV--row1-->tLogRow
  |
iterate
  |
tDBxxxInput("select * from tableName where gender="+row1.gender+" and status="+row1.status)-->tMap-->tDBxxxOutput

Best regards

         shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » How to pass two values dynamically

Board footer

Powered by FluxBB