Skip to Content
0
Former Member
Jan 28, 2014 at 09:12 PM

Looking for information

19 Views

Hi

Here is my requirement:

I have the below condition to be validated in my query transform.

not <table1>.Col1 in ('IZ','IT') AND <table1>.Col2 =' 3100011'

Instead of hard coding 'IZ,IT & 3100011 value used a Global variable and assigned the value to output value like below.

$Gv_output_value = '[$Gv_DCT_Value] and <table1>.Col2 = \' \' || [$Gv_MCU_Value]';

In the where clause in Query transform i used below.
not <table1>.Col1 in ('[$Gv_Output_Cardex_value]')

When i run the job, it fetched all the data and not properly taking the where clause coniditon. Not reallly sure where it is wrong and let me know your view.

Regards

Gannu