Horizontal column

Help Activities
, ,
1

i having excel file in which i having all header in column A and values in column B.I want get value on basis of header. e.g name-value(hemant),gender-value(Male).will someone help me to write linq query for this?
image

Forum Engagement Daily Reports
2

@Hemant_Deshmukh

  1. Best would be to use lookup activity in datatable or in excel to get values
  2. If you still need linq…then read data in dt then dt.AsEnumerable.Where(function(x) x(0).ToString.Equals("ValueOfColumnNameToGet")).FirstOrDefault()(1).ToString this needs to repeated in assign for each column you need

Cheers

3

Try below

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.