Specific Columns Value Replace in the DataTable

[Shyam_Pragash]

Hi Team,

Can tell me how to change specific Columns Values in the Datatable…

i tried linq quire

Out_Dt.AsEnumerable().Where(Function(r) r(“Employee Status”).ToString.Replace(“Active”,“InActive”).ToString).CopyToDataTable

In above code getting on error String to Boolean

Thanks
shyam

[Anil_G (Anil Gorthi)]

@Shyam_Pragash

Please try this in invoke code add outdt as in/out argument

Out_Dt.AsEnumerable().ToList.ForEach(Sub(r) r("Employee Status") = r("Employee Status").ToString.Replace("Active","InActive").ToString)

cheers

[Shyam_Pragash]

@Anil_G

Out_Dt.AsEnumerable().ToList.ForEach(Sub(r) r(“Employee Status”) = r(“Employee Status”).ToString.Replace(“Active”,“InActive”).ToString)

Can tell linq quries

[ppr (Peter Preuss)]

@Shyam_Pragash

Out_Dt.AsEnumerable().Where(Function(r) r(“Employee Status”).ToString.Replace(“Active”,“InActive”).ToString).CopyToDataTable

A where requires always a condition which evaluated to true or false

[HowTo] LINQ - First Start # Where Operator

This HowTo introduces how to use the Where operator. Introduction The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result. The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False. Example IPO Samples Comment Values: 20,3,17,22,10,25,5 A collection of Numbers Filter Condition: x > 15 x is …

Also have a look here:
How to Update Data Column Values of a Data Table | Community Blog

[Mohammed_Ismail_Rahid]

Out_Dt = (From row In Out_Dt.AsEnumerable()
Let empStatus = If(row(“Employee Status”).ToString() = “Active”, “Inactive”, row(“Employee Status”).ToString())
Select row.Field(Of Object)(“Column1”), row.Field(Of Object)(“Column2”),empStatus
).CopyToDataTable()

[Shyam_Pragash]

Hi @Mohammed_Ismail_Rahid

I have more than 85 Columns and have data… So that i want to change the specific columns value in the datatable…

Thanks
Shyam

[Mohammed_Ismail_Rahid]

In such cases, you can use a loop to iterate through the columns and apply the necessary changes.

[tazunnisa.badavide (Taj)]

If Not linq ,Use for each row in data table and provide an if condition inside
if:CurrentRow(“Employee Status”).Equals(“Active”)
then: use Assign activity:CurrentRow(“Employee Status”)=“InActive”

Regards!

[Mohammed_Ismail_Rahid]

Out_Dt.AsEnumerable().ToList().ForEach(Sub(row)
If row(“Employee Status”).ToString() = “Active” Then
row(“Employee Status”) = “Inactive”
End If
End Sub)
Hope this helps…

[Mohammad.Fuad]

Hey Shyam, can I know the number of columns in your datatable?

The solution would be helpful if you have few numbers of datacolumns.

(
From row In dt1.Copy.AsEnumerable()
Let country = If (row(“Country”).ToString = “USA” , row(“Country”).ToString.Replace(“USA”,“US”) , row(“Country”).ToString)
Select dt1.Rows.Add(row(“City”).ToString , country)
).CopyToDataTable

My datatable had 2 columns, City and Country. In the country column, replacement is done.If you have more columns, just add those in the select line.

[Shyam_Pragash]

Hi @Mohammad.Fuad

i have 74 Columns in the datatable.

[Anil_G (Anil Gorthi)]

@Shyam_Pragash

Did you try the invoke code?it is a linq only

Specific Columns Value Replace in the DataTable

@Shyam_Pragash Please try this in invoke code add outdt as in/out argument Out_Dt.AsEnumerable().ToList.ForEach(Sub(r) r("Employee Status") = r("Employee Status").ToString.Replace("Active","InActive").ToString) cheers

Cheers

[Mohammad.Fuad]

oh , then mine won’t be plausible .

[Shyam_Pragash]

Hi @tazunnisa.badavide @Anil_G @Mohammed_Ismail_Rahid
@Mohammad.Fuad @ppr

Thanks all i got the solution.

[Anil_G (Anil Gorthi)]

@Shyam_Pragash

Glad itsresolved.Happy Automation

Cheers

[Mohammed_Ismail_Rahid]

Can you share your solution

Cheers…

[Shyam_Pragash]

Hi @Mohammed_Ismail_Rahid

(From row In Out_Dt.AsEnumerable()
Let colInd = Out_Dt.Columns(“Employment Status”).Ordinal
Let col = If (row(“Employment Status”).ToString = “Active” , row(“Employment Status”).ToString.Replace(“Active”,“InActive”) , row(“Employment Status”).ToString)
Let ra = row.ItemArray.Take(colInd).Append(col).Concat(row.ItemArray.Skip(colInd+1)).ToArray()
Select Dt_Clone.Rows.Add(ra)).CopyToDataTable()

[Mohammed_Ismail_Rahid]

Thank You…
Happy Automation