Hi Team,
I’m using bulk add queue item activity and every time when i run the process null values getting added to the queue. i have debugged and it is showing the expected values and I couldn’t see any null values while debugging.
First print the datatable in a excel file by using write range workbook activity and check the datatable contains the data.
If there is no data in the datatable the values added to the queues as null.
Hope it helps!!
Hi @mkankatala the issue I’m facing is the first item which is being added to queue alone is null and rest other values in queue are as expected… only the first time in queue is null and as you suggested i used write range activity and it returns first row as empty which means there is null value.
Check the Datatable if it contains the data or not
Check your designed logic by debugging or giving log messages
Okay @naveenkumarr
That’s why it was adding the first queue as null.
If you want to remove the first row from datatable, let us know.
Hope you understand!!
1 Like
Hi @mkankatala yes i need to remove the first row. can you please help me on this?
Assign activity:
dataTableWithoutFirstRow = yourDataTable.AsEnumerable().Skip(1).CopyToDataTable()
1 Like
Take an assign activity before bulk add queue item activity.
=> Dt = Dt.AsEnumerable.Skip(1).CopyToDataTable
The above which removes the first row of datatable.
In the place of Dt replace the datatable variable.
Hope you understand!! @naveenkumarr
1 Like
Thank you @naveenkumarr
Happy Automation!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.