Video Screencast Help

Get data into "Key Value Pair" variable ??

Created: 15 May 2013 • Updated: 15 May 2013 | 3 comments
bkcbkc11's picture
This issue has been solved. See solution.

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

Operating Systems:

Comments 3 CommentsJump to latest comment

reecardo's picture

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

SOLUTION
bkcbkc11's picture

Hi Reecardo

It pointed me in the right direction, thanks.

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

BR bkcbkc11

 

 

reecardo's picture

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.