What activity can be used to modify the value of an existing cell in a DataTable?

Help
1

What activity can be used to modify the value of an existing cell in a DataTable?

A. Add Data Column Activity.
B. Add Data Row Activity.
C. Assign Activity.
D. Modify Cell Activity.

Thanks
Krishna

1 Like
2

Assign Activity

1 Like
3

Hi @krishnareddy

Go through these you will find a solution

Thanks,
Prankur

4

assign activity
dattable(row)(column) = [you value]

1 Like
5

Hi @venkat4u , @PrankurJoshi

I have created a datatable using build data table activity.
And now I am trying to insert values in the datatable using Assign activity.
However I am not able to assign, getting error “Assign: Category val in DT: Cannot create an L-value from the given expression with property ‘set_Item’ because the target object is null.”

This I think is because of DataTable not getting identified.
Is there a way to specify the size or number of rows to a DataTable?
Build_DT

6

Can you attach a sample? What are you assigning?

1 Like
7

Hi @PrankurJoshi,

I am trying to insert values string and Integer
Sample_insertDT.xaml (9.6 KB)

8

Sample_insertDT.xaml (11.8 KB)
attached the file

9

You have to use Add Data Row activity, as you can only assign some value to a cell if row is already there.

You are assigning a value to a specific cell but there is no row exists in the data table, so you will have to first add a row to table then you can update the cell value.

Thanks,
Prankur

5 Likes
10

Thanks . Yes adding an empty Data row before assign helped!

2 Likes