Automate

 View Only

  • 1.  Winshuttle Query - Inspection Types

    Posted 11-07-2022 08:44
    Hi guys.

    The material master inspection types use the field (ART) so when I add this to the material master query script, the different inspection types are displayed in a  single column. Does anyone know how to transpose the data so they are displayed in individual columns per material?

    For example, I want the data to look like this:
    Column A     Column B    Column C    Column D
     01                   0101               08                   09

    Currently, the query script with field ART displays like this:

    Column A
    01
    0101
    08
    09

    ------------------------------
    Andy Lewis | SAP Master Data Analyst
    Ortho-Clinical Diagnostics, Inc. | 1656711000
    ------------------------------


  • 2.  RE: Winshuttle Query - Inspection Types

    Posted 11-08-2022 02:34
    Hi Andy,
    I don't see a way to do so from within the material master query script, so I would run a little VBA script on your table.
    querying for material number, for as long as next material number equals the previous one, inserting a column with corresponding inspection type and deleting that line it copied from.
    hth, Jan

    ------------------------------
    jan ketele | release expert
    Xeikon Manufacturing NV | 003234431875
    ------------------------------

    Original Message


  • 3.  RE: Winshuttle Query - Inspection Types

    Posted 11-08-2022 07:04
    I use MM03 as a chained script to pull the types into separate columns.
    Material Number Plant Inspection Type (01)
    RMQAM-ART(01)    		 Inspection Type (01)
    RMQAM-ART(02)    		 Inspection Type (01)
    RMQAM-ART(03)    		 Inspection Type (01)
    RMQAM-ART(04)



    ------------------------------
    Dave Kelly | Sr Data Analyst/ Winshuttle Developer
    Dorman Products Inc. | (215) 712-5256dkelly@dormanproducts.com
    ------------------------------

    Original Message


  • 4.  RE: Winshuttle Query - Inspection Types

    Posted 11-08-2022 07:29
    Hi Dave, thanks very much for the response, much appreciated. Any advice on how to go about doing this would be most welcome. 

    Regards
    Andy

    ------------------------------
    Andy Lewis | SAP Master Data Analyst
    Ortho-Clinical Diagnostics, Inc. | 1656711000
    ------------------------------

    Original Message