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
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
'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)