Token | was not valid

rwnetwork — Mon, 10 Feb 2020 17:41:49 GMT

Hello

Getting this error that I cannot figure out when a tas400input step runs into a tmap:

"select fiinst,fddgrp,fdtype,fitype,fiigrp,fdstcd,fdarea,fdbank,fddate,fdmnst,fdmnar,fdmnbk
from data.fpf fpf
left join data.bankinst bi on fpf.fdmnst = bi.qistcd and fpf.fdmnar= bi.qiarea and fpf.fdmnbk = bi.qibank and fpf.fddgrp = bi.qiigrp
join data.instrmst inm on inm.fitype = fpf.fdtype and inm.FIIGRP = fpf.FDDGRP and inm.fiinst = bi.qiinst
where fdstcd = '"+((String)globalMap.get("X.State"))+"'
and fdarea = '"+((Integer)globalMap.get("X.Area"))+"'
and fdbank = '"+((Integer)globalMap.get("X.Bank"))+"'
and fddgrp = '"+((String)globalMap.get"(X.Group"))+"'
and fiinst = '"+((String)globalMap.get("X.ProductCode"))+"'
and fddate = (
Select Max(fddate) from data.fpf fpf 
left join data.bankinst bi on fpf.fdmnst = bi.qistcd and fpf.fdmnar= bi.qiarea and fpf.fdmnbk = bi.qibank and fpf.fddgrp = bi.qiigrp
join data.instrmst inm on inm.fitype = fpf.fdtype and inm.FIIGRP = fpf.FDDGRP and inm.fiinst = bi.qiinst
where fdstcd = '"+((String)globalMap.get("X.State"))+"'
and fdarea = '"+((Integer)globalMap.get("X.Area"))+"'
and fdbank = '"+((Integer)globalMap.get("X.Bank"))+"'
and fddgrp = '"+((String)globalMap.get("X.Group"))+"'
and fiinst = '"+((String)globalMap.get("X.ProductCode"))+"'
)
group by fiinst,fddgrp,fdtype,fitype,fiigrp,fdstcd,fdarea,fdbank,fddate,fdmnst,fdmnar,fdmnbk"

Any suggestions please?

Re: Token | was not valid

rwnetwork — Tue, 11 Feb 2020 16:23:20 GMT

Letting community know I figured this out.

There were non compliant characters coming through in the query. I copied and pasted the code from an email and in turn, it brought in odd and invisible characters. I placed the query in notepad++ and stepped through the query and edited it.

topic Re: Token | was not valid in Talend Studio

Token | was not valid

Re: Token | was not valid