[resolved] selecting rows where column value changed from previous row

[Anonymous]

how to implement this in talent with tMap. Don't know where to put 'limit 1'
SELECT a.*
FROM tableX AS a
WHERE a.StatusA <>
( SELECT b.StatusA
FROM tableX AS b
WHERE a.System = b.System
AND a.Timestamp > b.Timestamp
ORDER BY b.Timestamp DESC
LIMIT 1
)

[Anonymous · Accepted solution]

Hi,
There is no Limit on reading row in tMap which means selecting from the specified location with the specified line number, but you can make a limit in tfileinputxxx component. You can set "head", Footer and Limit in component setting.
Best regards
Sabrina