MxLoader

 View Only

  • 1.  Delete Individual Records Via MxLoader 8.3

    Posted 02-03-2022 08:48
    Is it possible to delete individual records or rows via MxLoader?

    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------


  • 2.  RE: Delete Individual Records Via MxLoader 8.3

    Posted 02-03-2022 11:31
    Hi Stevie,

    Short answer is yes, you should just change the value in C1 to "Delete."

    Do you get an error? If so can you please post that, a screenshot of your sheet, and whether or not you're using REST/OS?

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------

    Original Message


  • 3.  RE: Delete Individual Records Via MxLoader 8.3

    Posted 02-03-2022 12:17
    I've tried that before and it seems wipe out everything, depending on what table you're hitting. I guess you reduce your results to what you want to delete, the put delete in C1?

    Thanks

    Stevie

    ------------------------------
    StevieHollowayTufts University
    ------------------------------

    Original Message


  • 4.  RE: Delete Individual Records Via MxLoader 8.3

    Posted 02-03-2022 12:24
    Hi Stevie,

    That's correct. You can also insert a blank row to stop the file from executing all the rows. Say you only want to delete the first 10 records, add a blank row in after the 10th record and MxLoader will only action the records above the blank row.

    Please let me know if that helps or if you have any other questions.

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------

    Original Message


  • 5.  RE: Delete Individual Records Via MxLoader 8.3

    Posted 02-03-2022 17:28

    Thank you so much for that tip. 

    Stevie



    ------------------------------
    StevieHollowayTufts University
    ------------------------------

    Original Message


Related Content