DATA SHUTTLE

Eric Laitenberger
Eric Laitenberger ✭✭✭✭✭
edited 11/18/22 in Add Ons and Integrations

Hello,


I created a Datashuttle from a sharepoint by a unique number "X"

I would like that when this unique number disappeared from my source file, also it disappeared to my target sheet. Could you help me please, how can I do it.

Thanks community for your answer,


Eric

Tags:

Answers

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭

    Hi @Eric Laitenberger

    While configuring the data shuttle, you need to configure this on the Target section. In Workflow action, select "Merge data into the target based on a key column value" whereas in "Row options", check the last item that says "Delete rows that no longer match the filter criteria"

    I hope this helps.


    BR

    Amit WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/

    Best Regards
    Amit Wadhwani
    , Smartsheet Community Champion
    Smartsheet CoE, Ignatiuz, Inc., Exton, PA

    Did this answer help you? Show some love by marking this answer as "Insightful
    💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/

  • Eric Laitenberger
    Eric Laitenberger ✭✭✭✭✭

    Yes doesnt work.

    Because in my source file when a column change of status, it disappeared .

    In my target file, this column remained with the same statusIs it possible to have a call?