Creation of records based on conditions

[Former Member]

Hello experts,

I have a requirement in our project where the target record should be created only if a source field satisfies some condition.

for example

MT_Customer

     Records

          CustID

          CustName

Record in the target should only be created if length of CustName is greater than 5.

Could any one please let me know how to proceed?

Regards

Rishabh

[iaki_vila · Accepted solution]

Hi Rishab,

Following the past advices you can get your target. (May be you should share your schemas and we can check any difference).

Example:

Queues:

Hope this helps.

Regads.

[Former Member]

Thanks inaki was missing remove context.

[Former Member]

Thanks for your replies.

I know how to apply conditions, but based on condition how will record be generated.

I have tried using createif also, but was not able to achieve this with that also.

[Harish]

Hi Rishabh,

The logic provided by Udo and Naveen should work. Can you please share the screenshot of mapping and your test, so we can check where is the problem?

regards,

Harish

[naveen_chichili]

Hi Rishabh,

You would be able to achieve this by standard functions.

IF-->Customer Name -- Length--Greater than 5 -->Customer

Thanks,

Naveen

[udo_martens]

Hi Rishabh,

this is very basic standard stuff:

A boolean/if without else function combined with text/length function.

/Udo