topic Re: To change field_value in QlikView

To change field_value

dkbhatt51 — Mon, 13 Aug 2012 07:52:37 GMT

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:

X Y

VISIT 1
VISIT 3
VISIT 1	Yes
VISIT 3	Yes

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

Darshan

Re: To change field_value

suniljain — Mon, 13 Aug 2012 08:26:56 GMT

you can do only at script level during load of data .

Re: To change field_value

dkbhatt51 — Mon, 13 Aug 2012 09:57:37 GMT

Thanks Sunil - Agreed.

Can it be done without changing the source data? If so how?

Darshan

Re: To change field_value

Mon, 13 Aug 2012 12:13:15 GMT

Hope it helps!

Load X,
       Y,
       if(Y='Yes',X&'a') AS NewX
From TableName.xls

Re: To change field_value

dkbhatt51 — Mon, 13 Aug 2012 14:07:03 GMT

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

Thanks.

Re: To change field_value

Tue, 14 Aug 2012 05:35:28 GMT

Hey

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.

Thanks,

Attitude

Re: To change field_value

dkbhatt51 — Tue, 14 Aug 2012 10:59:12 GMT

Hi,

In a hurry I typed wrong - sorry about that.

The following syntax wroks for me:

T1:

Load X,

From abc.xls

T2:

Load Y,

if(Y='Yes', X&'a') as X resident T1;