Rhino ETL Cross Join

59 views
Skip to first unread message

Michael Charalambous

unread,
Aug 16, 2012, 4:52:55 AM8/16/12
to rhino-t...@googlegroups.com
Hi

Is it possible to perform a cross join in Rhino ETL?

Basically I need to merge two different InputCommandOperations. One of these operations returns a single row containing configuration information and the other contains the data to be processed. Neither input has any fields in common and I'm reluctant to just create a dummy field in both for the purpose of joining them together.

Thanks

Michael

Jason Meckley

unread,
Aug 16, 2012, 7:25:55 AM8/16/12
to rhino-t...@googlegroups.com
you could use a full outer join or as you suggested, create a dummy field to join the rows. I have used dummy/marker fields with great success.

Michael Charalambous

unread,
Aug 16, 2012, 11:59:49 AM8/16/12
to rhino-t...@googlegroups.com
Hi Jason

I ended up using the dummy/marker field approach.

Thanks

Mike
Reply all
Reply to author
Forward
0 new messages