Compare column name and value
Posted: Mon Nov 23, 2009 6:07 am
HI,
In the input i have 3 columns
ColA,ColB,ColC with the following values
MOS,MMS,PX
And i have a reference link(table) where all the valid values for these columns are stored in a table like below
Col1,Col2 with the following values
ColA,MOS
ColB,MMS
ColC,PX.
I want to validate whether the value in ColA(from input) i.e MOS is matching with the value in reference with the value ColA.
How can we achieve this..
In the input i have 3 columns
ColA,ColB,ColC with the following values
MOS,MMS,PX
And i have a reference link(table) where all the valid values for these columns are stored in a table like below
Col1,Col2 with the following values
ColA,MOS
ColB,MMS
ColC,PX.
I want to validate whether the value in ColA(from input) i.e MOS is matching with the value in reference with the value ColA.
How can we achieve this..