A
Arivazhagan K
Guest
hi,
I have to update one column based on the expression on the other column in the data table.
Col1 Col2 Col3 ColExp CalcCol
1 0 1 if(Col1="1" && Col2="1") CalCol=Yes else No
1 1 1 if(Col1="1" && Col3="0") CalCol= Yes else No
Actually, I have to read the each row in the above data table and update the value on the calcCol column based on the ColExp column value. So finally my data table would be like this below table.
Col1 Col2 Col3 ColExp CalcCol
1 0 1 if(Col1="1" && Col2="1") CalCol=Yes Yes
1 1 1 if(Col1="1" && Col3="0") CalCol= Yes No
Thanks
Arivazhagan K
Continue reading...
I have to update one column based on the expression on the other column in the data table.
Col1 Col2 Col3 ColExp CalcCol
1 0 1 if(Col1="1" && Col2="1") CalCol=Yes else No
1 1 1 if(Col1="1" && Col3="0") CalCol= Yes else No
Actually, I have to read the each row in the above data table and update the value on the calcCol column based on the ColExp column value. So finally my data table would be like this below table.
Col1 Col2 Col3 ColExp CalcCol
1 0 1 if(Col1="1" && Col2="1") CalCol=Yes Yes
1 1 1 if(Col1="1" && Col3="0") CalCol= Yes No
Thanks
Arivazhagan K
Continue reading...