Replace values if header is equals to specific name

Help Activities
, ,
1

Hi Friends,

I have a query regarding replace entire value to “x” if header is equal to “Smith, John”.

image
image982×371 11.2 KB

Forum Engagement Daily Reports
2

Hi @Jeeru_venkat_Rao

Use the below code in Invoke Code activity

DT.AsEnumerable().ToList().ForEach(Sub(row)
    If DT.Columns.Contains("Smith, John") Then
        row("Smith, John") = "x"
    End If
End Sub)

Pass DT as In/Out in invoke code activity arguments

Regards,

3

showing error code in invoke window–>It saying DT cannot be used in lambada expression.

Can you make a xaml for this?

image

4

Hi @Jeeru_venkat_Rao

You can use invoke VBA activity to achieve this

This image shows an automation script setup using UiPath to open an Excel file named "Test.xlsx" and invoke a VBA macro named "UpdateColumnValues" from a code file "UpdateColumnValues.txt". (Captioned by AI)
This image shows an automation script setup using UiPath to open an Excel file named "Test.xlsx" and invoke a VBA macro named "UpdateColumnValues" from a code file "UpdateColumnValues.txt". (Captioned by AI)631×703 23.3 KB

This image shows a VBA macro code snippet for Excel designed to update column values based on a specified column name in the first row, highlighting key parts of the code. (Captioned by AI)
This image shows a VBA macro code snippet for Excel designed to update column values based on a specified column name in the first row, highlighting key parts of the code. (Captioned by AI)1100×557 22.5 KB

Find attached Xaml for your testing.
DataFormatting_X.zip (37.0 KB)

Hope this helps :slight_smile:

5

Thanks bro, I have already written VBA code.

I want separate entries for player.
Let me explain it.

Player1 visited John Smith & Rose mary in between 1-7 jan

So I want 2 entries.
In 1st entry John Smith have existing data and in front of Rose just x,x
In 2nd entry Rose mary have existing data and in front of John x,x

The image displays a spreadsheet titled "WWE Data" consisting of medical details of three players, highlighting their diseases and treatment dates, with a filtered "Output required" section below showcasing only specific combinations of Player Names, Auth Docs, and Diseases. (Captioned by AI)
The image displays a spreadsheet titled "WWE Data" consisting of medical details of three players, highlighting their diseases and treatment dates, with a filtered "Output required" section below showcasing only specific combinations of Player Names, Auth Docs, and Diseases. (Captioned by AI)1151×532 20.5 KB

Note:- If player visited only 1 person in date range 1-7 then single entry