How to return only the first string

[Former Member]

Hi Guys,

I have a mapping where I am creating a filename from data in within my data file, I am using one of my variables i.e. Account

The data looks like this

Account:

123

123

123

456

456

456

789

789

789

What I want is to is return only the first row u201C123" and concatenate it with a constant to make up the filename.

Any help will be appreciated.

Kind Regards,

CJ Bester

[rajasekhar_reddy14 · Accepted solution]

very simple

use copy value standard function like below.

Account------->copyvalue(0)----------->
                                                                  CONCAT------------->TARGET
                                     Constant------->

Regards,

Raj

[monicabhosale]

Hello,

To get first row value to crete filename you can create one variable at target side and using UDF you can retrieve only first variable value and store in temporary created variable at target side and use that variable in file name.

else you can use count and using that store first row variable in your temporary target variable if you dont want to go with UDF.

i hope this will help you.

Thanks

Monica

[Former Member]

In message mapping, use the standard node function collapseContext to get the first value. Keep the context of the Account field at the root level

[Former Member]

Awesome it works thanks