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

[god_prophet]

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'

[_Manoj_Kumar_ · Accepted solution]

Hello @god_prophet 

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