Replace a data with the particular column cell using the column name?

Help
, , ,
1

I want to replace a data with a new data to a particular cell of datatable using column name?

2

Hi @Manish540,

Can you please elaborate your topic with some screenshots or with something else?

Thanks & regards,
Apurba

3

Use Assign Activity,

inputDt.Rows(RowIndex)(ColumnIndex) = “yourValue”

Example:
inputDt.Rows(2)(1) = “yourValue”

Please refer this workflow for more details,

ReplaceParticularValueinDt.xaml (8.6 KB)

Thanks!

4

Their is already a data in a particular cell of a particular column , now I have to replace that data with new data?
I’m performing this operation inside the for each row, so i want to do this replacement to all the rows of a particular column name.?
I used row.item(“Columnname”) = newdata. but its not working or updating that column?

5

Just by using the column name I have to do it…

6

How to find the rowindex and columnindex of “row.item(“Columnname”)” of this???..

Their is any other method like… we can use regex or linq queries??

7

Can you share your xaml or sample Excel sheet with dummy data.

8

ConvertParticularDateFormat.xaml (10.4 KB)
TestData.xlsx (8.3 KB)

9

Hi @Manish540,

Please use Assign activity and assign like below -
row(“ColoumnName”)=“ColoumnName”

Thanks & Regards,
Apurba

10

The section where i want to assign the newdata , i have commented out…

11

Its not working.

12

Hi Manish540,

Column names usualy dont change so u can use

YourString = “ColumnName”

Write Cell
YourString

13

TestData.zip (10.0 KB)

Please check this file.

Thanks!

14

Ya I used “OutDataTable2.Rows(i)(“Column2”) = newdata”.
It worked for me…
Thank You:smiley: everyone for your reply

1 Like
15

Its not opening?..

16

DateTimeParse.xaml (8.8 KB)

Thanks!

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.