tdbinput query to tmap

[AdamS632]

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.

 

[AdamS632 · Accepted solution]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina