Need to convert one SQL Query into LinQ

Help Studio
, ,
1

Hi, Need help with LinQ Query. I have SQL Command code for Excel as DB. Need to replace it with LinQ. Pls help

  1. Select Invoice # from DBTAB where PO # = **######

  2. Select Count (Distinct(Invoice #))from DBTAB where PO # = **#####

  3. Select * from DBTAB where PO#= *#### and Invoice #= **#####

Help.

2

@ShekharRPA

For DB, SQL query is more than enough

Let’s us know why you are in need of LinQ for this?

Thanks

3

Actually, I need to use this data filtration in Excel. Change request from ****. And I am not good at LinQ

4

Last one I will use .Select. remaining are 1 and 2

5

@ShekharRPA

Check below for filtering the Excel

Reference using Filter Datatable

Reference using LinQ

Hope this will help you

Thanks

6

Ok. I will check them.

7

@ShekharRPA

You can also use Filter Datatable activity as below

1st
image

2nd
image

For the count of the Datatable

Hope these will help you

Thanks