Expand my Community achievements bar.

SOLVED

how to append a string to an attribute using enrichment activity

Avatar

Level 4
 
 

@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

1 Accepted Solution

Avatar

Correct answer by
Level 1

Hi DishaSharma

 

In an enrichment activity you select the Add Data option

JoshW_0-1708557158121.png

 

Then Data linked to the filtering dimension

JoshW_1-1708557204259.png

 

Then Data of the filtering dimension

JoshW_2-1708557253771.png

 

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

JoshW_0-1708560017112.png

 

 

 

 

 

View solution in original post

5 Replies

Avatar

Community Advisor

Hello @DishaSharma 

 

You can do it like this:

'slipn_'+@SLIP_NUMBER

     Manoj
     Find me on LinkedIn

Avatar

Correct answer by
Level 1

Hi DishaSharma

 

In an enrichment activity you select the Add Data option

JoshW_0-1708557158121.png

 

Then Data linked to the filtering dimension

JoshW_1-1708557204259.png

 

Then Data of the filtering dimension

JoshW_2-1708557253771.png

 

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

JoshW_0-1708560017112.png

 

 

 

 

 

Avatar

Level 4

@_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

 

Avatar

Level 4

@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

Avatar

Level 2
'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)