Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Its possible, but do have single data?
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