I have a reference table ABC_REF which contains certain database name. Now, I want to take that reference table in a parameter and check for that value in an expression transformation.
I am passed the reference table name ABC_REF in the default value while defining the parameter( DE_VALUES). Is that fine?
Also, below is the condition in my expression transformation:
IIF(HC_Y_N_='N' AND IN(Data_Element,$DE_Values), 'Fail','Pass')
But this only giving me pass condition even though failed one exist.
Can anyone please suggest how to achieve that?
Retrieving data ...