Workflow Soluiton

 View Only

  • 1.  Get data into "Key Value Pair" variable ??

    Posted May 15, 2013 05:45 AM

    Hi All

     

    I have a SQL query which retrieves two  columns. I need to add all rows into a Key Value Pair variable.

    Can anyone help ?

     

    BR bckbkc11



  • 2.  RE: Get data into "Key Value Pair" variable ??
    Best Answer

    Posted May 15, 2013 06:48 AM

    You can use an Single Value Mapping component. Specify KeyValuePair as the datatype and map the process values in.



  • 3.  RE: Get data into "Key Value Pair" variable ??

    Posted May 15, 2013 03:49 PM

    Hi Reecardo

    It pointed me in the right direction, thanks.

    I used the multi value mapping componet instead, it works super.

    BR bkcbkc11

     

     



  • 4.  RE: Get data into "Key Value Pair" variable ??

    Posted May 15, 2013 03:53 PM

    Should have read your first post more closely... thought you only had one row. But yes, if you have many rows, the Multi Value Mapping is the way to go.