Match row with config file

Help Studio
, ,
1

I am trying to match specific Keyword from a Config file. Can somebody help me with that.
This is what I got so far

image
image584×732 20.6 KB

image

Thanks

2

Hi,

Can you elaborate your requirement?

Do you already have config variable from excel sheet?
What is your input and output you expect.
etc.

Regards,

3

My Variable for Config Sheet 1 is in_config. The variable for sheet “Type” is “in_TypeDataTable”.

I have a list of property which I have to match with a keyword located in config file sheet “Types”

image

If the keyword matches with the property list I need to write that in the new file.

I hope this make sense.

I am stuck here
image

4

Hi,

The config file sheet is the above image,right?
Can you share specific sample of a list of property?

If assume it’s {"Hotel","Inn"} as listProerty, the follwoing expression filter if it exists in Types column of datatable.

filteredListProperty = llistProperty.Where(Function(s) in_TypeDataTAble.AsEnumerable.Any(Function(r) r("Types").ToString=s)).ToList

Then filteredListProperty = {"Hotel"} , you can write each item in ForEach activity.

Regards,

1 Like
5

thanks heaps

1 Like
6

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