# Help- issues with Transforms connect

**URL:** <https://forum.confluent.io/t/help-issues-with-transforms-connect/2564>\
**Category:** Kafka Connect\
**Created:** [24 August 2021 15:55 UTC](https://forum.confluent.io/t/help-issues-with-transforms-connect/2564 "2021-08-24T15:55:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![baddoyz](https://avatars.discourse-cdn.com/v4/letter/b/50afbb/32.png) [@baddoyz](https://forum.confluent.io/u/baddoyz)\
**Post date:** [24 August 2021 15:55 UTC](https://forum.confluent.io/t/help-issues-with-transforms-connect/2564/1 "2021-08-24T15:55:21Z")

</div>

Hello everyone,  
I need your help because I don’t find a solution.  
My goal is to go to : **text\_LASTNAME\_FIRSTNAME**

My config :  
\> “transforms”: “createKey, extractString, dropPrefix”,

> ```
> "transforms.createKey.type": "org.apache.kafka.connect.transforms.ValueToKey",
> "transforms.createKey.fields": "LASTNAME",
> "transforms.extractString.type":"org.apache.kafka.connect.transforms.ExtractField$Key",
> "transforms.extractString.field":"LASTNAME",
> "transforms.dropPrefix.type": "org.apache.kafka.connect.transforms.RegexRouter",
> "transforms.dropPrefix.regex": "*_json",
> "transforms.dropPrefix.replacement": "text_${LASTNAME}", 
> 
> ```

My message:

> [  
> {  
> “topic”: “\*\*\*\*\*\*\*\*\_json”,  
> “partition”: 0,  
> “offset”: 0,  
> “key”: “TESTEST”,  
> “value”: {  
> “LOCALSTART”: “2021-08-21 05:48:20:00”,  
> “LOCALEND”: “2021-08-21 05:50:00:00”,  
> “LASTNAME”: “plip”,  
> “FIRSTNAME”: “plop”,
> 
> ```
> },
> "__confluent_index": 0
> 
> ```
> 
> }  
> ]

Thank you everyone…

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [23 September 2021 15:55 UTC](https://forum.confluent.io/t/help-issues-with-transforms-connect/2564/2 "2021-09-23T15:55:43Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
