Need to add spaces before stribg but getting "Number of invalid arguments on function 'Left'" | Community

Level 6

Solved

Need to add spaces before stribg but getting "Number of invalid arguments on function 'Left'"

Forum|Forum|1 year ago
July 15, 2024
1 reply
517 views

I need to updated a field, for this I need to make a reconciliation of 2 fields:

my_original_field -> my_upcoming_field.

My original_field has 4 spaces at the beginning. However "my_upcoming_field" doesn't.
So I tried: ' '+my_upcoming_field

But I'm getting: 07/15/2024 11:17:45 AM QUE-370012 Number of invalid arguments on function 'Left'

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Manoj_Kumar

Hello @god_prophet

Try to move the concat logic to an enrichment and then use that newly created field in update data activity.

Community Advisor

Accepted solution

Community Advisor

Hello @god_prophet

Try to move the concat logic to an enrichment and then use that newly created field in update data activity.

Manoj Find me on LinkedIn