topic Re: Expression Builder Syntax MisMatch in tMap in Talend Studio

Expression Builder Syntax MisMatch in tMap

Anonymous — Wed, 27 May 2020 22:44:13 GMT

Guys, I will be working on creating logic using Inner Join in tMap component.

Request: Two inputs with the same fields(columns), I trying to find matched and unmatched records from both inputs.

Fields: Email, FirstName, LastName & City

Criteria: Check each and every fields in both inputs using join, If all the field in the row matches it goes to Matched output else Error path. Example: If a File A holds ABC as FirstName and FileB holds different value or blank it will be rejected and Staus should be updated as "Not Matched".

Components: tFileInput Delimited (2)-->tMap -->Output - Matched & Output - Rejected

I tried the below syntax and it fails to provide the status as "Not Found" as this is used for 'Email' field check.

((!row5.Customer_Email_Address.equals(row6.Customer_Email_Address)) ? "Not Found" :
(!row5.MMTFirstName.equals(row6.MMTFirstName) ? "Not Matched" : "Error")

Can you please help to provide the workaround. Screenshot attached for reference.

Re: Expression Builder Syntax MisMatch in tMap

manodwhb — Fri, 29 May 2020 06:12:46 GMT

@y2k_karthi ,use the below one and let me know and fields data types should be string.

(!row5.Customer_Email_Address.equals(row6.Customer_Email_Address)) ? "Not Found" :
(!row5.MMTFirstName.equals(row6.MMTFirstName) ? "Not Matched" : "Error")

Re: Expression Builder Syntax MisMatch in tMap

Anonymous — Mon, 01 Jun 2020 17:06:16 GMT

Hi @manodwhb, Thanks for your response.

This is still not working, it throws the same status "Not Found" (1st case expression) for both the cases. Can you help me to get rid of this? Attached the ss for reference.

Thanks in Advance!!

tMapExpression.jpg

Re: Expression Builder Syntax MisMatch in tMap

manodwhb — Tue, 02 Jun 2020 07:03:15 GMT

@y2k_karthi , can you give sample input for those two columns and required output ,so that I will test from my end. you need to break it down to see where the problem is

Re: Expression Builder Syntax MisMatch in tMap

Anonymous — Tue, 02 Jun 2020 11:26:21 GMT

@manodwhb - I have attached data file(Input_1 & Input_2), One sheet holds four and another with three records.
I'm looking to get the rejected data with "Not Found" status for missing one and "FirstName Not Matched" for values mismatched column FN.

Also, added a sheet to show how I need the rejected O/P.

Thanks,
Karthi

Data.xlsx

Re: Expression Builder Syntax MisMatch in tMap

manodwhb — Tue, 02 Jun 2020 12:00:18 GMT

@y2k_karthi , your job design should be like below to get the required output. and sheet 1 is Main and sheet 2 should be lookup.

JoboutputtMap settings

Re: Expression Builder Syntax MisMatch in tMap

Anonymous — Tue, 02 Jun 2020 12:30:53 GMT

@manodwhb - I agree with your point. This will work by checking one field(First Name), Whats the possible way to accomplish to check multiple fields(Last Name, Country, State, Zip Code, etc.,?

And, Whether it work only by using tHashOutput & Input? My idea to capture the O/P after tMap.

Re: Expression Builder Syntax MisMatch in tMap

manodwhb — Tue, 02 Jun 2020 13:00:42 GMT

@y2k_karthi , you need to check manually if you want to check for each and every field the same way.

you cannot connect o/p from the same origin that you need to combine two outputs into singe right.