Discussion Board for collaboration on QlikView Scripting.
I searched the tags in the community discussions but could not get a clue. I would appreaciate any help on the following:
I have two fields X and Y as below:
I want to change the Field X value to 1a and 3a (as applicable) if Field Y value = Yes. I know I can use InputField function but it becomes tedious to manually change the large data set.
Many thanks in advance
you can do only at script level during load of data .
Thanks Sunil - Agreed.
Can it be done without changing the source data? If so how?
Hope it helps!
Load X, Y, if(Y='Yes',X&'a') AS NewXFrom TableName.xls
if(Y='Yes',X&'a') AS NewX
if I use the At titude's script it creates another field NewX.
I therefore tried
Load X, Y, if(Y='Yes',X&'a')as X
and it worked fine
Yours is incorrect! You cannot give same column name for two or more fields from same table. That's the reason I have named it as NewX for your understanding. So the answer which I have given is correct.
Please let me know if you have any questions.
In a hurry I typed wrong - sorry about that.
The following syntax wroks for me:
if(Y='Yes', X&'a') as X resident T1;