Robotic Process Automation (RPA)

Hi I an copying rows from one data table to add to another.

The logic is working and copying the rows to the target table

My problem is it is not copying all the data it only copies certain fields from the source table.

I have checked the source table and all the data is there but when i copy the filtered rows it doesn't copy all fields

Any ideas why this would happen?

Hello, Thomas

I believe it'll be better to understand if we check the scrips logic. Could you paste here the part of your script where you get the table, filter it, and copy values to another table, so we can try to figure out what's going on?

Hi I an copying rows from one data table to add to another.

The logic is working and copying the rows to the target table

My problem is it is not copying all the data it only copies certain fields from the source table.

I have checked the source table and all the data is there but when i copy the filtered rows it doesn't copy all fields

Any ideas why this would happen?

Here is the line of script Giulianele

copyRows --target ${AdtTable} --where "[New Ship] = \'Y\'" --dataTable ${ShpsSimpleTable} SimRowsCopied=success SimNoOfRows=changedrowscount

Hello, Thomas

I believe it'll be better to understand if we check the scrips logic. Could you paste here the part of your script where you get the table, filter it, and copy values to another table, so we can try to figure out what's going on?

Hi I an copying rows from one data table to add to another.

The logic is working and copying the rows to the target table

My problem is it is not copying all the data it only copies certain fields from the source table.

I have checked the source table and all the data is there but when i copy the filtered rows it doesn't copy all fields

Any ideas why this would happen?

I've faked some examples here and seems that if the information that you're looking for have any character that don't match to what do you want (in this case "Y"), it won't get it. For example, if your data table has two entries but one has a blank space at the beginning (" Y"), this value won't be copied.

A suggestion could be to try to clean any extra character from this column before you copy values from it.

Here is the line of script Giulianele

copyRows --target ${AdtTable} --where "[New Ship] = \'Y\'" --dataTable ${ShpsSimpleTable} SimRowsCopied=success SimNoOfRows=changedrowscount

Hello, Thomas

I believe it'll be better to understand if we check the scrips logic. Could you paste here the part of your script where you get the table, filter it, and copy values to another table, so we can try to figure out what's going on?

Hi I an copying rows from one data table to add to another.

The logic is working and copying the rows to the target table

My problem is it is not copying all the data it only copies certain fields from the source table.

I have checked the source table and all the data is there but when i copy the filtered rows it doesn't copy all fields

Any ideas why this would happen?