how to append a string to an attribute using enrichment activity

[DishaSharma]

@AndreaBriceno

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

Hi All

Please help

how to append a string to an attribute using enrichment activity

my ask is from query activity we are receiving value of 'slip number' as

123,

446,

457like that

i want to add a new attribute via enrichment activity--name of new attribute is 'custom slip number' and value should be equal to

slipn_123,

slipn_446,

slipn_457

please help how can i do this

[_Manoj_Kumar_]

Hello @DishaSharma 

You can do it like this:

'slipn_'+@SLIP_NUMBER

[Josh-W · Accepted solution]

Hi DishaSharma

In an enrichment activity you select the Add Data option

Then Data linked to the filtering dimension

Then Data of the filtering dimension

From the next screen you can select Add and create an expression like this

[DishaSharma]

@_Manoj_Kumar_ 

in my case data type was integer

query activity we are receiving value of 'slip number' as--integrer datat type

123,

446,

457like that

i want to add a new attribute-SHOULD BE OF STRING TYPE via enrichment activity--name of new attribute is 'custom slip number' and value should be equal to

slipn_123,

slipn_446,

slipn_454

'custom slip number=

'slipn_'+@SLIP_NUMBER

I THINK I NEED TO DO CoNVERSION HERE CAN YOU PLEASE GIVE ME CORRECT CODE TO CONVERT TOS TRING FIst thrn append

[DishaSharma]

@Manoj_Kumar_ 

in my case data type was integer

query activity we are receiving value of 'slip number' as--integrer datat type

123,

446,

457like that

i want to add a new attribute-SHOULD BE OF STRING TYPE via enrichment activity--name of new attribute is 'custom slip number' and value should be equal to

slipn_123,

slipn_446,

slipn_454

'custom slip number=

'slipn_'+@SLIP_NUMBER

I THINK I NEED TO DO CoNVERSION HERE CAN YOU PLEASE GIVE ME CORRECT CODE TO CONVERT TO STRING FIst then append

[rahulbabu]

'slipn_'+@SLIP_NUMBER 

 It automatically converts to string datatype. If you still want conversion of integer to string you use ToString(@SLIP_NUMBER). It will converts integer to string. 

'slipn_'+ToString(@SLIP_NUMBER)