Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Overwrite Table Column using Variable

Hi,

I have a Table with one Element

Name, Email

John , dummy@gmail.com

and I would like to overwrite Email column value using the text introduced from an input field mapped with a varible (Var_Email)

so at the end I will have (for example)

Name, Email

John , John@gmail.com

Is it possible to do this?

T.

2 Replies
senpradip007
Specialist III
Specialist III

Its possible, but do have single data?

crusader_
Partner - Specialist
Partner - Specialist

Hi,

In Chart use expression

= Name&right(Email,len(Email)-index(Email,'@',-1)+1)

If you need to keep original data add above expression in LOAD statement as Email_Alias

HTH.

Andrei