on 11-15-2010 8:40 PM
Hi, Friends:
I have used Mapping Variables without problem in the past.
Now when I try to bring multiple mapping variables (on target side) in same data flow editor, I can not do it.
The idea is that our RFC lookup return multiple values, we need to store them temprorily into variables.
I can use UDF for this purpose, just do not understand why I can not use variable feature in this situation.
Regards
Liang
Hi Liang,
If you Double click on the 2nd Temporary variable of the target, it will not come in to the editor. You have to press the mouse on the 2nd variable and do drag & drop the field to the editor window. Then it will come and you can use in the mapping.
Thanks,
Nabendu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Nabendu:
Thanks for your reply.
I tried the mouse press and drag, it only bring the variable to graphical editor in source format, means it can map to something.
Now I need it in target format, means I need to map to it.
More accurate, I need to map to them in one data flow edtor (multiple variables in target side).
Any ideas ?
Thanks
Liang
Hi Liang,
If i understand your issue correctly, you need to map the same value to some target fields. Say for example a Constant value "K" to target fields : field1, field2, & field3.
So for this, click(single click) on the target field & just do a mouse press and drag them to the graphical editor one by one. In this way, you will be able to achieve mapping for all these target fields simultaneously.
For example, first click on target "field1" , use mouse press and drag this target field to the graphical editor. Repeat the same process for each target field so that you can use multiple target fields in the same mapping.
I hope this helps.
Regards, Gaurav.
Hi Liang,
I have got the point but you can not map different Mapping Variables in the same flow editor. You can use <ReturnAsXML> and then can write Java code to populate different field values. Otherwise you have to go Hash Table where you can put the data for temporary usage.
Thanks,
Nabendu.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.