Subselect in Case

[Former Member]

Hi Experts, I have a View, i am Converting the View to DI job, In The View  there is a Case Statement, In the Case statement there is subselect Case when AAAA.A = XX and AAAA.B is not NULL           and AAAA..C in (select D from [XXXXXX].[GGGGGGGG] where R= EEE and  H is NULL) Then 'In Review'       Any Idea Please Thanks

[venkataramana_paidi · Accepted solution]

Hi Uhdam,

You can check the below post . It has similar requirement of yours . You can achieve using the lookup_ext with sql override.

Thanks & Regards,

Ramana.

[former_member208363]

Did you try with SQL transformation?

[former_member187605]

Check out the built-in lookup function.