topic Re: Needs help...to fix Syntax Errors in Talend Studio

Needs help...to fix Syntax Errors

Edi1 — Wed, 31 Mar 2021 16:09:45 GMT

Hello, This is the palettes design (not connected display but I connect before running it)

Help me with Talend tMap Syntax/code for the following requirements:

The requirement is to...Enter fund

(Funds are: 311145B9B, 31165B9B) (I will try type as a String)

Please write code here: to enter fund

The requirement is to Enter Fund code

(Fund code is: 1111-00-0B67J) (I will try type as a String)

Please write code: to enter fund code

Re: Needs help...to fix Syntax Errors

Edi1 — Wed, 31 Mar 2021 16:10:33 GMT

Re: Needs help...to fix Syntax Errors

gjeremy1617088143 — Wed, 31 Mar 2021 19:13:50 GMT

So you have to do a lot of work edi, first connect tFileinputExcel to a tLogRow (desactivate all other components)and see in the console if you see data extracted from the excel file . If it’s ok delete the tlogrow and connect tFileinputExcel to tMap (in the tMap you’ll see the input schema on his left side . Make a new output in the tMap(on his right side) and add the column you want in the output schema. Then connect the tMap to a new tLogRow . Now in the tMap you can drag and drop the column from left side(input) to left side(output). But sincerely i think you must read documentation about tMap. A good document i can recommand to you is the talend beginner guide. Send me Love and Kudos

Re: Needs help...to fix Syntax Errors

Edi1 — Wed, 31 Mar 2021 21:17:39 GMT

Thanks gjeremy!

So I send liked to your post.

Thanks very much! I know how to do the tfiles, components, output schemas, and all that good stuff. My questions is surrounding the code in tMap for some of the fields. I think it will work best if I start the tMap code expression over and post when I run into an error.

Thanks!

Re: Needs help...to fix Syntax Errors

Anonymous — Thu, 01 Apr 2021 03:50:29 GMT

Hello,

What's your expression in tMap? Could you please elaborate your case with an example with input and expected output values?

Here is an article about: https://community.talend.com/s/article/tMap-expression-syntax-TCiHW

Hope it will help.

Best regards

Sabrina

Re: Needs help...to fix Syntax Errors

Edi1 — Thu, 01 Apr 2021 14:42:27 GMT

Ok, will do so. Thanks

Re: Needs help...to fix Syntax Errors

Anonymous — Fri, 02 Apr 2021 06:00:35 GMT

Hello,

Feel free to let us know if there is any further help we can give.

Best regards

Sabrina