topic Re: Please verify syntax is formatted correctly in Talend Studio

Please verify syntax is formatted correctly

Edi1 — Tue, 30 Mar 2021 13:56:54 GMT

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

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

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Tue, 30 Mar 2021 16:23:57 GMT

Hi could you explain the debit field ?

if debit is a string and row1.Post_Key() is a string you should use : row1.Post_Key().equals("debit")? "60" : "70"

Re: Please verify syntax is formatted correctly

Edi1 — Tue, 30 Mar 2021 20:59:07 GMT

Hi, Thanks for your reply. Yes, I have it as a string 60 is debit and 70 is credit. Should I add "credit" in front of 70? Like this.... row1.Post_Key().equals("debit")? "60" : (" credit")"70"

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 06:59:01 GMT

Hi Edi, first point it's weird to have parenthesis in your column name (Post_Key() you should avoid this in your column name),

so if row1.Post_key() is a string and is value is "credit" or "debit" and your corresponding output value is "60" or "70" then :

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

if if row1.Post_key() is a string and is value is "60" or "70" and your corresponding output value is "debit" or "credit" then :

row1.Post_Key().equals("60")? "debit" : "credit"

it depend of wich value you have in input and wich value you want in output.

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 13:18:23 GMT

Excellent! Thanks gjeremy. This will be helpful for me to assist me with updating it.

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 14:19:59 GMT

Hello!

I am getting an error message that it cannot convert from boolean to string. Can you please help me with this syntax to resolve error?

I tried this at first:

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

I received error above cannot convert from boolean to string so I cast to a string like this, below. It is still not working. I am getting error as stated above.

((String) row1).Post_Key().equals("debit")? "60" : "70"

Help please!

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 15:28:02 GMT

Where are you using it? In a Tmap ?

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 15:30:58 GMT

if it’s in a tMap could you send screenshot of the tMap and input output schema ?

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 15:40:57 GMT

If you want to convert boolean to String use: String.valueOf(Your boolean) instead of (String)(your boolean), but result will be « true » or « false »

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 15:57:17 GMT

Yes, in tMap

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 16:02:56 GMT

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

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 16:03:01 GMT

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 16:08:31 GMT

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

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 16:09:43 GMT

Fileinputexcel must have a schema

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 16:12:11 GMT

can you send me screenshot of tfileinputexcel schema

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 17:19:53 GMT

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

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 19:34:59 GMT

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 »

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 19:38:50 GMT

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!

Re: Please verify syntax is formatted correctly

gjeremy1617088143 — Wed, 31 Mar 2021 20:21:33 GMT

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

Re: Please verify syntax is formatted correctly

Edi1 — Wed, 31 Mar 2021 21:25:19 GMT

Yes, that will be helpful. Thanks