How to pass a String correctly

[Anonymous]

hi

how can i pass String in active express Builder ?

am doing like this

am not getting any output.

[manodwhb]

I belive that your not sure about your data what you have it wil work with row1.DeviceId.equals("LAB0115ANS3131") or row1.DeviceId.startsWith("LAB0115AN3131") or row1.DeviceID.contains("LAB1216AN3012").

could you please share sample data in excel ,i will provide you a job export.

[Anonymous]

try using single quotes so row1.DeviceID.equals('LAB0115AN3131') or row1.DeviceID = 'LAB0115AN3131'

[manodwhb]

i just created a job for you with sample data ,please find the attached job

Flag_changing.zip

[Anonymous]

few days ago i have avast antivirus installed in my pc. avast automatically remove my installed Talend Studio. Come in My Topic How to pass String Correctly.
now am using tFileInputExcel for tmap input its working which u all provide me a solution in same case its not working with MicroSoft SQL Server

[Anonymous]

thanks every body now am feeling good and i will start again work with Talend Studio

[Anonymous]

I think it has something to do with The map generation of sql scripts and how the columns where created. I noticed when I created columns in oracle sql that when I used quotes it wouldn't work since the tmap query doesn't use quotes to select the columns. I resolved this by creating my columns without quotes using SQL developer. I think you are encountering something similar.