Script Logic - Concatenate two variables

[former_member278039]

Good Morning,

It is possible in Script Logic to concatenate two variables?

*FOR %VAR1% = PRODUCT.REG

*FOR %VAR2% = S_REGION.NUMBER

*WHEN TIME

*IS "2016.03"

*REC(FACTOR = 3, PROFIT_CTR = %VAR1%%VAR2% )

*ENDWHEN

*NEXT

*NEXT

If not, what are the possible solutions?

Dank,

Amit

[former_member186338 · Accepted solution]

"It is possible in Script Logic to concatenate two variables?"

Yes, it's possible!

"*FOR %VAR1% = PRODUCT.REG" - absolutely incorrect syntax! What do you mean?

What do you want to achieve from business logic??

Please read:

And test scripts in UJKT!

Vadim

[former_member278039 · Accepted solution]

Hi Vadim,

Thanks a lot.

I just made it:

*SELECT(%ABC%,<Property>,<Dimension_1>,"ID=%Dimension_1_SET%")

*SELECT(%XYZ%,<Property>,<Dimension_2>,"ID=%Dimension_2_SET%")

*WHEN TIME

*IS %TIME_SET%

*REC(FACTOR = 1, <Dimension_Target> = %ABC%%XYZ% )

*ENDWHEN

Thanks.

Regards,

Amit Pratapcim

[former_member186338 · Accepted solution]

Unfortunately you script will work ONLY single member %Dimension_1_SET%" and %Dimension_2_SET%"

Vadim

[former_member278039 · Accepted solution]

Hi Vadim,

Yes, you  are absolutely correct.

Any trick?

[former_member186338 · Accepted solution]

Unfortunately - no description of the business requirements. Nothing to talk about without understanding what you want to calculate.

Vadim