开发者

Merging a stream with table input records NOT in the stream

I am trying to pull together a complex Kettle transformation on a set of patient data. I have several table input steps that query a MySQL table that assembles patient rows into a stream. Each table input step appends a "patient stage" column (e.g. "PreOpScheduled" and "PostOpScheduled").

Now I need to select all the rows of the patient table that are not part of the other table input steps and set the patient stage column to "Active". These rows need to be appended to the stream for further processing.

"Select from patient w开发者_如何学运维here not in patient stage stream"


just use a merge join step, and do an outer join, and some row filtering after that.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜