LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Changing field values within column

    Employee
    Posted 11-26-2014 10:50

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mw9286

    I would like to replace one field value with multiple field values, preferably doing a looking in a matrix. but any solution would be great. In the example: If value TV SERVICES is found replace and retain TV SERVICES with 3 field values TV SERVICES, MOVIE & SPORTS


    current column(TV PACKAGE), new column(TV PACKAGE)
    TV SERVICES TVSERVICES
    MOVIE
    SPORTS


    Thank you


  • 2.  RE: Changing field values within column

    Employee
    Posted 11-26-2014 17:08

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Is this what you're looking for? I made up some package numbers and what services they contain. The customer data only contains the package number. A look-up is done to pull in the services. I then "expand from list" to break out a record for each service.
    Attachments:
    createNewRecords.brg