Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hello,
Great it is fixed and thanks for sharing your solution with us on Community.
Best regards
Sabrina