Concatenation of 3 Numc info objects at transformation level

[Former Member]

HI,

I want to concatenate 3 Numc type Info Objects At transformation level.

Can I use a formula? But I Only find concatenation of 2 strings in formula.

I have searched previous posts but no help.

Please suggest

Regards,

Rahul S

[KodandaPani_KV · Accepted solution]

Hi,

you can use the CONCATENATE Concatenate function at  tranformation

ex- academic period(numc - 3), academic year (numc - 4)- source level have

one more object i addded into target cube.(numc-  7.)

after i applied the concatenate funcation while loading the data form source to taget

Thanks,

Phani.

[Former Member · Accepted solution]

But concatenate is working for 2 strings not for 3 NUMERIC field.

Please help

[karthik_vasudevan · Accepted solution]

Hi Rahul

First concatenate two fields and populate that in a variable which you need to declare based on the length.

Then concatenate the variable and the third field. Populate this as your result.

Please correct me if my understanding is not correct.

Regards

Karthik

[Former Member · Accepted solution]

I want to do it in formula of field (say NUM4).

I would like to concatenate NUM1 Num2 And Num3 at single transformation itself to form Num4

Not by abap code or something.

Regards,

Rahul S

[karthik_vasudevan · Accepted solution]

I am afraid if there is an option for that.

The transformation clearly shows that we can only use two fields.

But what is the challenge in using routines. If you let us know that, we could help you in that way.

Routines are used in such conditions when a standard formulae cannot help. Why cant you try that mate!

Regards

Karthik

[karthik_vasudevan · Accepted solution]

You are lucky mate!!

It works if you use the concatenate as below in transformation formula

I have tried something new because of you. Thanks for that.

Try this and let me know if it doesn't work

Regards

Karthik

[Former Member · Accepted solution]

I will definitely try this. Thanks!!

[karthik_vasudevan · Accepted solution]

It worked for me. So it should work for u as well, provided the total length of three NUMC fields should be same as the length of one target field.

Don't forget to update the result please.

Regards

Karthik

[Former Member · Accepted solution]

Can I have the one target field length greater ?

[karthik_vasudevan · Accepted solution]

It should be basically like this.

Source Field 1 = 003

Source Field 2 = 004

Source Field 3 = 005

Target Fields should be equal or more than the sum of above three. So, it should be >= 12

Regards

Karthik

[Former Member · Accepted solution]

Numc data type doesn't have conversion  routine that's why this doubt arised whether more length will be good too or not

Regards,

Rahul

[karthik_vasudevan · Accepted solution]

Yes Rahul. That's a reasonable question . But most of the cases, we cant conclude anything without trying it. I believe in practically trying rather than theoretical notes.

When you try, you will get to know many more things than you normally know. Initially, I said its not possible to use three fields, but we were able to achieve it after trying.

Keep it simple. Try and you will get to know many things.

All the best!!

Regards

Karthik

[former_member418141]

Hi

I would suggest to use Fromula at transformation

concatenate var1 var2 var3 into result.

Because of that are numeric fields, respect the leading 0!

regards

Tom

[Former Member]

Please elaborate as to what formula.

Concatenate (Num1, Num2 , num3) is not being accepted at transformation level formula.

Regards,

Rahul Sindhwani