Needs help...to fix Syntax Errors

[Edi1]

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

[Edi1]

[gjeremy1617088143]

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

[Edi1]

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!

[Anonymous]

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

[Edi1]

Ok, will do so. Thanks

[Anonymous]

Hello,

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

Best regards

Sabrina