formatbyexample issue

[mohammadaamir_khan]

Hi All,

I am doing mapping to various table based on condition. I am creating table node based on condition.

In one field mapping I am using FormatbyExample. It is working fine.

Issue happens when data is for another scenario and FormatbyExample should not be used as that table node is not supposed to create. It is giving error "queues do not have the same number of values" because data is not for this scenario.

How to avoid this error.

Thanks

[suchitatomar]

The prerequisite for FormatByExample function is both the queues should have Same number of values. To generate the result queue, the function takes the values from the first queue and combines them with the context changes from the second queue

In message Mapping right click on format by example function and check whether your both input Queue has equal no of values.

Let me know if this helps .

[former_member190293 · Accepted solution]

Hi!

You could use conditional functions (IfWithoutElse/IfThenElse), for example, to check if FormatByExample should be used or not.

Regards, Evgeniy.

[mohammadaamir_khan · Accepted solution]

Hi Evgeniy,

If I am putting the IfThenElse, it is not returning complete list if condition is true.

[mohammadaamir_khan · Accepted solution]

Hi Evgeniy,

i used ifWithOutElse and UseoneasMany combination solved the issue.

[mohammadaamir_khan]

Hi Suchita,

Both queue are different and incoming data is not for this scenario al together, but PI is still trying to map it though parent node is not created with CreateIf negation.

I want to avoid the error so that mapping will give proper node result.