Mapping Problem

[Former Member]

Hi,

I hav 5 fileds in my source structure and 13 fields in target structure . For 5 fields in target structure , its direct mapping from source .For remaining 8 fields in target structure , i need to FILL WITH SPACES .

How to fill with spaces .

Regards ,

Hem.

[justin_santhanam · Accepted solution]

Chand,

Map everything with constant [ ] to the target field.

Best regards,

raj,

[Former Member]

Hi hem chand

Is there specific length for those 8 blank fields ? If this is so then you can write a generalized UDF which will fill spaces at target .. Suppose field 8 needs to be filled with 10 spaces, field 9 with 20 spaces. then specify this using UDF. Use 10, 20 as a constant parameter to User Defined Function.

constant(10) -

---

> UDF -

---

> target field 8 and so on....

let us know if this is the way you want to implement.

Regards

[Former Member]

Hi Hem,

in graphical mapping, take constant and double-click it.........here in constant value put as many spaces as you need......then map this constant[ ] field to your target nodes for filling them with spaces.

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA

[Former Member]

Hi,

Other 8 field fill the Constant OR Disable field.

[justin_santhanam]

Kumar,

We can't use Diable fields in his case, coz he specifically says that he needs spaces. So the option is to use constant, with space containing in it.

Best regards,

raj.

[former_member529475]

HI Hem

Assign the constant[] to the remaining 8 fields....

Cheers..

VAsu

<i>** REward Points if found useful **</i>