Issue in Data Table

Help
, ,
1

Hello Team,
Hope you are doing good. I am processing a workflow for salesOrder edit.
Here i am taking the value of SalesOrder from Queue and Date from config file and the processing further steps.
At the end i want to put both values to DataTable.
But i am getting error in Add Data row.
Please find the attached screenshot. Please let me know for any more information required.
Build Data Table:

image
image2560×1440 368 KB

Below is the screenshot for Add Data row for which i am getting an error.
image
image2560×1440 369 KB

The intention is to put the entry in data table after every successfull iteration

Thanks & regards,
Amit Kulkarni

2

I had some quries,

Why u are looping through an empty datatable out_DT_Data since it is empty, it will throw error.

is this workflow is whole under loop?

can u explain please

3

It is not possible to loop through a table and at the same time add a new row

Simply use add data row, without looping :slight_smile:

4

Oh I thought is to first build and then add.
Its not under a loop.It will take entries from the queue

5

Ok Thanks will try it but in add data row i am not able to add arguements as show in the pic.

6

Hi @amitkk_84 there is ‘.’ at the beginning of each variables in the add datarow, remove that and validation error will be gone.
image

Regards

Nived N

Happy Automation

7

I did that but i am getting error as
Add Data Row: Object reference not set to an instance of an object.

image
image2560×1440 336 KB

Also if the first iteration is over and if there are any items in queue it will agaun process the same workflow and in ideally it should create a new entry in add data row.

Can u please help

8

Hi you are getting this error because you have not initialized the datatable.
You need to put back build datatable activity.

9

I put the build data table back and declare local variable and it is working fine but my concern is
for first time it will load the entry but for the second iteration will it overwrite or automatically write it below the first value.
Or do i need to add for loop.Currently my workflow is shown below.

image
image2560×1440 333 KB

10

In this case the problem is not the add row activity but the build datatable activity. It will try to re-initialize an existing datatable.

You have two options:

  1. move the activity build datatable in a part of a process that runs only once (eg when reading the config file)
  2. Keep build datatable activity there but use an if statement to check if datatable is nothing .
1 Like
11

Hello Dimibot,
So what should be done in this case?

12

I don’t know all the requirements of your process and where exactly you need to use this datatable so i can not give you an answer to your question on which option to choose :frowning:

13

@amitkk_84

Hi,

Take a variable, Variable type DataRow and assign the value Datatable.NewRow.
For example there is a Add DataRow which has testDataTable.
Then suppose you want to add first data item in a datatable.

Firstname = row(0).ToString
FirstRowData = Datatable.NewRow
FirstRowData(“FirstName”) =Firstname
(AddDataRow)

Please feel free if any doubt.

Regards
Anand

14

hi @amitkk_84 ,

In add data row activity, in arrayrow property add expression as
{var1,var2}

When you do that, you can see some “.” operator, remove that. And check whether this workflow is running or not.

don’t use any for each row activity.

15

Thanks a lot it worked.

16

Will check that out and let you know

17

Thanks a lot.Will check

18

Hello Dimibot,
As per your suggestion, i have done blow things.
Declared the build datatable in config which is shown below.

image
image2560×1440 372 KB

Now in the Process, i am using add data row as shown below.

image
image2560×1440 347 KB

Now i have a query here as since i have created an arguement and add as B_DT , now how can i use the value in the add datarow where i need to mention the Datatable.

19

Hi @amitkk_84 ,

Mention over here →
image

20

Yes but that value is not getting displayed if i search for it.
Am i doing something wrong.