on 03-05-2012 11:25 AM
we have the following requirement:
there is a field called sequence number which is appearching in 4 nodes in the source (all the nodes are optional 0 to unbound ,and contains same value),need to populate sequence value in the target node even one single node at source contains value.
Can any body suggest
source node -> Field -> remove Context -> collapse Context -> equals with "" -> if without else -> and in the second input of if give the output of collapse context -> target field.
According to this it will take even if a single value is present in the source side and map it to target else it'll igonre.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajiv,
Please try this if it works for you,
SeqNumber--->removecontex->exists->splitbyvalue-Eachvalue---->target.
Thanks and regards,
Ram.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can try with this UDF of type Context
public void passValues(String[] a,ResultList result,Container container){
int i;
for(i=0;i<a.length;++i)
{
result.addValue(a<i>);
}
}
sequence number(source) -
>UDF------> Sequence number (target)
Regards
Anupam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
I think you can try with use oneasmany .
Regards,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
there is a field called sequence number which is appearching in 4 nodes in the source (all the nodes are optional 0 to unbound ,and contains same value),need to populate sequence value in the target node even one single node at source contains value.
Not sure what you meant by sequence value. Did you mean it like this?
SeqNum -> removeContext -> count -> Target
or
SeqNum -> removeContext -> Index: 1..1 -> SplitByValue:eachValue -> Target
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use exits function with condition(if-else).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.