Please verify syntax is formatted correctly

[Edi1]

Is this Talend syntax correct or am i missing a variable?

row1.Post_Key() == debit? "60" : "70"

[Edi1]

tMap, not connected yet. Excel File input, Generic schema for output. Thanks Gjeremy

[Edi1]

[gjeremy1617088143]

First of all connect tfileinputexcel to a tMap and a tmap to a tlogrow and desactivate all other components

[gjeremy1617088143]

Fileinputexcel must have a schema

[gjeremy1617088143]

can you send me screenshot of tfileinputexcel schema

[Edi1]

Let me see if I can get it in a posting format, but to give you an idea of what I am trying to do for now below:

Schema for inputFile is:

Schema: Post_key

Data Type: String

debit is value for Post key it will output "60"

credit is value for post key it will output "70"

row that will be output when run is "60" , "70"

schema: Account will give outputs (example: 1090.90)

Thanks

[gjeremy1617088143]

if input row name is row1 and column is Post_key (string type) and your column output is a string and if when Post_key equal « credit » Then output value is « 60 » else « 70 » , the syntaxe is :

row1.Post_Key.equals(« credit »)?  « 60 »:  « 70 »

[Edi1]

Great, I will try what you stated. This should be helpful. I will connect tfileoutout to tmap and then connect tmap to tLogRow. Run....then connect output files,...Thanks!

[gjeremy1617088143]

Tomorow i’ll send you screenshots of a similar job.

[Edi1]

Yes, that will be helpful. Thanks