ID number in a Column

Help Activities
, ,
1

Hi All,

I am wanting to check that all the employee numbers in a column are also on the headcount report (Different File). I am looking at using the Cint value but not sure how to do this. Would this search all ID numbers in IE “Dt_Responses” against the ("Dt_Headcount)

Also how would I assign the Cint value to the DataTable?

2

Hi @csanders ,

Maybe you could explain in terms of what needs to be done by providing sample data, so that we can have a more visual look on what is the Input and How you would transform it to get the output.

Also, the initial statements mention that you would want to perform a comparison between two files, but the last statement points to an update. So we are not able to understand clearly what is needed.

3

Hi @csanders

If you want to Convert the Column value to Integer

cint(CurrentRow("Column_Name").ToString)

image
image759×343 17.6 KB

u can use Lookup datatable activity if you want to look value against the Employee number record.

image
image1276×731 53.2 KB

Note: Lookup value should be string. so u need to convert the value if you want to look in the different datatable

IF we get better Input and output scenario we can give better solution for that!!!

Thanks
VP