topic Re: Overwrite Table Column using Variable in QlikView

Overwrite Table Column using Variable

Fri, 30 May 2014 10:32:58 GMT

Hi,

I have a Table with one Element

Name, Email

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

Is it possible to do this?

senpradip007 — Fri, 30 May 2014 10:41:24 GMT

Its possible, but do have single data?

crusader_ — Fri, 30 May 2014 10:41:50 GMT

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