2 Replies Latest reply: Oct 16, 2018 1:40 AM by Øystein Kolsrud RSS

    How-To Remove Data after _ on load

    Duston Moore

      We use our customer numbers in many tables but they are not always kept in the same format. For orders the customer numbers will be 12345_0, 12345_1, 12345_2. The number after the _ represents a different ship to. For credit/debit memos the customer numbers will not have any thing after the primary number for example: 12345 instead of 12345_0. We are using the order customer numbers as a key. Is there a way for me to connect these either on or after load?