How to compare variable with the datatable item


#1

How to compare the variable which contains certain value with the data table. Value may change in the variable i.e state name. Suppose there is a variable 1:Jamba, Hyderabad,
Hyderabad TELANGANA
Pin-Code: 500047 INDIA and
Datatable contains: Column 1: TELANGANA
Column 2: HARYANA


#2

Hi @mhk15,

Column_value.contains(“variable”) method can be used.
Prior to that For each Row should be used to loop through data table.


#3

No its not working… I have with same


#4

Is it possible to post a picture of your excel sheet ? Just to understand how it looks.


#5

Yeah sure, I am sharing my XAML file since data is in datatable itself. STATEZONEMAPPING.xaml (9.5 KB)


#6

I have made some modifications in the xaml.
STATEZONEMAPPING.xaml (12.8 KB)

Check and let me know whether the requirement is fulfilled.


#7

Thanks… It helped me to solve my problem…