topic tdbinput query to tmap in Data Quality

tdbinput query to tmap

AdamS632 — Fri, 15 Nov 2024 22:29:38 GMT

I am using a tdbinput with mySQL.

In the query spot I have the following:

"SELECT aa.tType,

i.iDate,

i.previousIDate

FROM account as aa left join

(select pId, iNumber, iDate, LAG(iDate, 1) OVER (PARTITION BY pId ORDER BY iDate) as previousIDate

from sales

where substr(iNumber,1,2)='IN') as i on aa.pId=i.pId

and aa.tDate>i.previousIDate

and aa.tDate<=i.iDate

and aa.tId != i.iNumber

order by aa.pId, aa.tDate, i.iNumber"

This all works fine and returns results. But when I hook this up to a tmap to then do some more manipulation the tmap doesn't show anything as the input table. Normally the tmap will show the input table. I am not sure how to get the tmap to work or if there is another suggestion on how to map data that can be merge with other data.

Re: tdbinput query to tmap

AdamS632 — Fri, 07 Oct 2022 13:54:03 GMT

figured it out, just needed to manually map the values into the row7 part of the tmap. Normally they auto generate from a regular tdbinput. Once I mapped them all the data was available.

Re: tdbinput query to tmap

Anonymous — Sun, 09 Oct 2022 09:42:37 GMT

Hello,

Great it is fixed and thanks for sharing your solution with us on Community.

Best regards

Sabrina