Perform join on multiple columns with OR condition

[shahidbakshi]

Hi All,
need some help rgd data stage PX.
If S1 and S9 are two data sets, and we want to join those on the follwoing conidtion and need some output.

S1.OI_TEXT_REFER = S9.TEXTID OR S1.LI_TEXT_ID = S9.TEXTID OR S1.PO_SHIP_TEXT_ID = S9.TEXTID OR S1.PO_TEXT_ID = S9.TEXTID OR S1.CT_SHIP_TEXT_ID = S9.TEXTID OR S1.CT_TEXT_ID = S9.TEXTID

How to perform that.

[pradeep_nov18]

[quote="shahidbakshi"]Hi All,
need some help rgd data stage PX.
If S1 and S9 are two data sets, and we want to join those on the follwoing conidtion and need some output.

S1.OI_TEXT_REFER = S9.TEXTID OR S1.LI_TEXT_ID = S9.TEXTID OR S1.PO_SHIP_TEXT_ID = S9.TEXTID OR S1.PO_TEXT_ID = S9.TEXTID OR S1.CT_SHIP_TEXT_ID = S9.TEXTID OR S1.CT_TEXT_ID = S9.TEXTID

I think you can perform in lookup stage by giving the lookup condition, Perform lookup on one common column for both dataset

[ray.wurlod]

You can do it with six separate reference inputs to the Lookup stage.

[shahidbakshi]

Hi All,
need some help rgd data stage PX.
If S1 and S9 are two data sets, and we want to join those on the follwoing conidtion and need some output.

S1.OI_TEXT_REFER = S9.TEXTID OR S1.LI_TEXT_ID = S9.TEXTID OR S1.PO_SHIP_TEXT_ID = S9.TEXTID OR S1.PO_TEXT_ID = S9.TEXTID OR S1.CT_SHIP_TEXT_ID = S9.TEXTID OR S1.CT_TEXT_ID = S9.TEXTID

I think you can perform in lookup stage by giving the lookup condition, Perform lookup on one common column for both dataset

In lookup condtion we only get the primary links column not refrenced link columns, so I don't think so anything can be done by that.

[ray.wurlod]

Rot. You get KEY columns (unless you have a Lookup File Set on the other end). In this context this means "search key", not "primary key".