Multiply two columns using Linq Query

[amalmarella (Amal M)]

Hi Everyone,

I want to multiply two columns in datatable using linq query (both columns are of type Double)

@ppr @PrankurJoshi @Palaniyappan @NIVED_NAMBIAR

[PrankurJoshi]

Hi @amalmarella

You can invoke a code like this

 var_DT.AsEnumerable().ToList().ForEach(r=> r.SetField("yourColumnName",r.Field<Double>("FirstColumn")*r.Field<Double>("SecondColumn")));

Thanks,
Prankur

[Divyanshu_Divyanshu]

If your xaml is in C# then only use the above code.

[amalmarella (Amal M)]

@PrankurJoshi

var_DT.AsEnumerable().ToList().ForEach(r=> r.SetField("yourColumnName",r.Field<Double>("FirstColumn")*r.Field<Double>("SecondColumn")));

getting below error

[Divyanshu_Divyanshu]

var_DT.AsEnumerable().ToList().ForEach(Function (r)
r.SetField(“yourColumnName”,r.Field(“FirstColumn”)*r.Field(“SecondColumn”)))

Use this one

[PrankurJoshi]

@amalmarella he is correct its a C# code. Thanks @Divyanshu_Divyanshu

[NIVED_NAMBIAR (NIVED N)]

Hi @amalmarella

You can try this way and get the product of the 2 columns in a array too

data_arr= dt1.Select(Function(row) (CDbl(row(column1))*CDbl(row(column2))).ToString).ToArray()

Try this way too

Regards

Nived N

Happy Automation

[amalmarella (Amal M)]

@Divyanshu_Divyanshu

var_DT.AsEnumerable().ToList().F

Thanks Ankur & divaynshu it is working , Thanks nived for your response