useOneAsMany Error Root Cause

[Former Member]

Hello Experts,

Good Day!! I am getting the following error in useOneAsMany node function.

Too many values in the second queue in function useOneAsMany. The number of values for all contexts must be the same as the number of values for the third queue

If ,I need to verbalise the root cause in one line what can I say?

Can I say its due to number of values in contexts and number of values in queues?

Thanks in advance,

Vikas

[former_member182412]

Can you close the question so that it will be helpful for whoever come across this in future, they can quickly find the answer without reading all the answers and guess which one could be the correct answer.

[former_member182412]

Hi Vikas,

You can solve this issue by using below mapping. Pass second field to both second and third arguments of useOneAsMany and after the function you can use spltByValue(Each Value) like below.

Regards,

Praveen.

[Former Member]

Thanks Praveen for a very nice explanation.

So I can say that its failing because of values mismatch, right?

Thanks in advance,

Vikas

[former_member182412]

Yes it is failing because of values mismatching in second and third queue.

[former_member182412]

Hi Vikas,

To useOneAsMany first and second queues number of context changes should be same (fiirst queue should be single values in the context, second queue multiple values in the each context), second and third queues the number of values should be same without taking considerations of number of contexts (third queue each context should be only one value)

I hope it clarifies your question.

Regards,

Praveen.

[Former Member]

Thanks Raghu and Praveen,

Can you please let me know how to verbalise the root cause?

can I say the root cause as the values mismatch or need to verbalise it bit more? If so what will those words be?

Thanks in advance,

Vikas

[former_member186851]

Already did Vikas

The first two parameters must contain the same number of contexts while the last two parameters must contain the same number of values.

[Former Member]

Thanks Raghu and Praveen,

Can you please let me know how to verbalise the root cause?

can I say the root cause as the values mismatch or need to verbalise it bit more? If so what will those words be?

Thanks in advance,

Vikas

[Former Member]

Thanks once again Raghu.

So can I say the root cause as the values mismatch or need to verbalise it bit more? If so what will those words be?

Thanks in advance

Vikas

[former_member186851]

Hello Vikas,

Sorry for that !! I misunderstood the question.Below is the criteria for Use one as many.Its failing because of values mismatch.

The first two parameters must contain the same number of contexts while the last two parameters must contain the same number of values.

[Former Member]

Thanks Raghu.

But the error is saying about second and third queue

Too many values in the second queue in function useOneAsMany. The number of values for all contexts must be the same as the number of values for the third queue

Is it applicable for the above error as well?

Thanks in advance

Vikas

[former_member186851]

Hello Vikas,

Its because the first and second input queue of UseOneAsMany function does not have the same number of context changes.