Data table column to list with no duplication

[Hazem_Saleh]

Hello all

agian i found solution in VB

> Blockquote

but not c#
i have data table want to create list of customer name without duplication ,
Then i need to query the data table against the customer name so i have small datatable with only one customer rows,

Any tips !

[supermanPunch (Arpan)]

@Hazem_Saleh

i have data table want to create list of customer name without duplication ,

Hi @Hazem_Saleh ,

I believe the c# Representation would be as below :

DT.AsEnumerable().Select(r=>r("Customer Name Column").ToString()).Distinct().ToList()

Let us know if this doesn’t work

[ppr (Peter)]

@Hazem_Saleh

create list of customer name without duplication

• As mentioned by @supermanPunch
• Also as an option using YourDataTableVar.DefaultView Approach
• in newer LINQ (depending on selected TargetFramework) DistinctBy Operator

[Hazem_Saleh]

Thanks,
i have this issue "Method name expected "

[ppr (Peter)]

@supermanPunch

DT.AsEnumerable().Select(r=>r("Customer Name Column").ToString()).Distinct().ToList()

DT.AsEnumerable().Select(r=>r["Customer Name Column"].ToString()).Distinct().ToList()

try [ ]

[Hazem_Saleh]

Thanks
but cant covert list to a string!

im trying fetchDataDT_IN.AsEnumerable().Select(r=>r [“COMPANYNAME”]).select (r=>r.tostring())Distinct().ToList(); but still no luck

[supermanPunch (Arpan)]

@Hazem_Saleh

im trying fetchDataDT_IN.AsEnumerable().Select(r=>r [“COMPANYNAME”]).select (r=>r.tostring())Distinct().ToList(); but still no luck

@Hazem_Saleh ,

We see a Difference in the expression in the Screenshot and the one you have provided in the form of text below it.

Could you double check on the expression used ?

[Hazem_Saleh]

Good morning,

Blockquote fetchDataDT_IN.AsEnumerable().Select(r=>r [“COMPANYNAME”]).ToString().Distinct().ToList().ToString();
if i dont use the last .tostring i get this error

[supermanPunch (Arpan)]

@Hazem_Saleh

image1255×210 10.2 KB

@Hazem_Saleh ,

There is a misplace of brackets in your Expression.

Have you Checked with the Suggestion already provided above :

@ppr

DT.AsEnumerable().Select(r=>r["Customer Name Column"].ToString()).Distinct().ToList()

We don’t see this exact expression used in your workflow.

[ParasTripathi]

DataTable.AsEnumerable().Select(Function(x) x(“Column1”).ToString()).Distinct().ToList()

Pls try this this will work

@Hazem_Saleh if that will work then pls mark it as solution for my hard work

[ppr (Peter)]

@ParasTripathi

DataTable.AsEnumerable().Select(Function(x) x(“Column1”).ToString()).Distinct().ToList()

we just summarize the given inputs:

@Hazem_Saleh

agian i found solution in VB

> Blockquote

but not c#

And counterchecked:

Kindly note: the needed statement ending ;

And Also:

So with the help from @supermanPunch you should finalize it and get it working, when:

• statements are carefully ported to your code
• any specifics (e.g. variablename, columnnames…) are edited as needed

[Manish540 (Manish Shettigar)]

Hi @Hazem_Saleh ,

We can have C# linq’s in the Invoke Code activity as shown below,

companyNames(List of String) = dt1.AsEnumerable().Select(ra => ra.Field<String>("COMPANYNAME")).Distinct<String>().ToList<String>();

We have to set the language to CSharp in Invoke Code activity property section as per below screenshot,

Arguments:-

Hope this may help you

[Hazem_Saleh]

Thanks icant find list as a type
do i need to defined it first ?

[Hazem_Saleh]

@Manish540

companyNames(List of String) = dt1.AsEnumerable().Select(ra => ra.Field(“COMPANYNAME”)).Distinct().ToList();

Thanks its working now

[Hazem_Saleh]

Hello again,
Is it possible to do the same but we get the datatable with the row Values!

[ppr (Peter)]

@Hazem_Saleh

Is it possible to do the same but we get the datatable with the row Values!

Maybe you are looking for the following:

@ppr

Also as an option using YourDataTableVar.DefaultView Approach

[Hazem_Saleh]

Thanks, but i still want to have the raw values under this unique column names,

ABC,1
CDE,2