Look up data table only finds first match

[E.T.S]

Hello,

I have a look up data table activity - however I would like to configure this to enable multiple matches rather than just the first. Is there a way of achieving this?

I have attempted to use filter data table however the column name I am looking for in is a date format (even though it sis a string type variable) therefore the filter data table activity fails.

Cheers

[ashokkarale]

@E.T.S,

You should be able to achieve this by LINQ. Just describe the conditions to any LLM and it will give you the required LINQ for this.

Thanks,
Ashok

[jawagarraja123]

Hey @E.T.S

Sure, I can help once you share the input file and describe what you expect in the output screenshot.

cheers

[E.T.S]

Hi,

Thanks for your reply,

The column looks like this:

I would like the rows containing the value 2 to be put into a different data table

Cheers

[jawagarraja123]

Hey @E.T.S
Provide sample input
and i will work on it .

Cheers:

[E.T.S]

Hi,

Thanks for your reply.

I have managed to figure it out using:

dt.AsEnumerable().
Where(Function(row) row(“01-05-2024”).ToString().Contains(“2”)).
CopyToDataTable()

Thanks for offering to work on it! Cheers