Robotic Process Automation (RPA)

 View Only
  • 1.  Copying rows from a table

    Posted Mon March 20, 2023 12:57 PM

    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?



    ------------------------------
    Thomas Weston
    ------------------------------


  • 2.  RE: Copying rows from a table

    Posted Mon March 20, 2023 01:54 PM

    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?



    ------------------------------
    Giulianele Alves Barbosa
    ------------------------------



  • 3.  RE: Copying rows from a table

    Posted Mon March 20, 2023 02:14 PM

    Here is the line of script Giulianele

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



    ------------------------------
    Thomas Weston
    ------------------------------



  • 4.  RE: Copying rows from a table

    Posted Mon March 20, 2023 03:47 PM

    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.



    ------------------------------
    Giulianele Alves Barbosa
    ------------------------------



  • 5.  RE: Copying rows from a table

    Posted Tue March 21, 2023 09:49 AM

    Thanks Giulianele, I'll that.



    ------------------------------
    Thomas Weston
    ------------------------------