Need to extract data from database

[Vicky_K]

Consider database as separate excel as database
Consider input as separate excel as input data

I need out put as o/p coulmn

Can you tell me logic

Thanks and regards,
Vicky

[Vicky_K]

I need that city name if that emp code is present in database

[Srini84 (Srinivas Kadamati)]

@Vicky_K

You can use Join Datatables activity and the Join Type will be Inner Join

Hope this may help you

Thanks,
Srini

[Anil_G (Anil Gorthi)]

@Vicky_K

say your input data is read into datatable dt

You can use this query Select Emp_Code,City from [TableName] Where Emp_code IN (String.Join(",",dt.AsEnumerable.Select(function(x) x("Emp_Code").ToString)))

Assuming your emp_Code column in db is string if its not then Cint(x("Emp_Code").ToString) is to be used

cheers

[Vicky_K]

Hi all,
I use look up data table activity it can give the solution for me thanks for your reply

Thanks,
Vicky