Reords split up

[kettle_anonymous]

Is there any way we can split up the record based on some condition and insert them into two diff tables??

[MattCasters]

Yes, use a Filter step and specify BOTH target steps: one for when the condition results to "true" and one for when the condition results to "false".
If you have a complete tree, you obviously need to implement multiple filters.
If you don't want a certain branch of a tree, simply point it to a Dummy step.

HTH,
Matt