AnsweredAssumed Answered

Selecting Different CRT's Based On Condition

Question asked by vijayalakshmi.kuppala990564 on Jun 21, 2018
Latest reply on Jun 21, 2018 by amitash.pattnaik983074

Hi, can anyone help me for below Requirement.

  1. I have two Cross Reference Tables,

      i) PurchaseDetails CRT

 

    ii) Orders CRT

2. My source record contains Fields like Status and SOL.

   I am getting SId value to target profile by looking up to The CRT tables based on SOL value.

3. Conditions are:

         If the Status Field is "Y", I need to take value for filed SId from Purchase Details CRT based on SOL value.

         If the Status Field is "N", I need to take value for filed SId from Orders CRT based on SOL value.

    

Thanks & Regards,

Vijaya Lakshmi.K

Outcomes