topic Re: To Rename a field in QlikView

To Rename a field

upaliwije — Mon, 03 Mar 2014 04:24:48 GMT

I have a sales table consisting of following fields

Date

Dept (AA,BB,CC,DD,EE,AB,AC)

Product

Sales Person

Amount

In the load script I want to merged two dept into one.

sales:

LOAD Date,

if(Dept='AB','AA',if(Dept='AC'='CC'))as Dept, //( AA+AB as one and AC and CC as one dept)

Product,

Sales Person,

Amount

from sales.qvd

(qvd);

After the load I want to Dept dimension to consists of following Dept only.

AA,BB,CC,DD but not the AB and AC

But in my output I get only AA and CC as dept.

Pls help me to solve this problem

Re: To Rename a field

er_mohit — Mon, 03 Mar 2014 04:30:44 GMT

TRY THIS

if(wildmatch( Dept,'AA','BB','CC','DD','EE'),Dept) as Dept

hope it helps

Re: To Rename a field

amit_saini — Mon, 03 Mar 2014 04:31:47 GMT

Hi Upali,

You can do like this:

sales:

LOAD Date,

if(Dept='AB','AA',if(Dept='AC'='CC'))as Dept, //( AA+AB as one and AC and CC as one dept)

Product,

Sales Person,

Amount

from sales.qvd

(qvd)

Where Dept<>AB and Dept<>AC;

Thanks,

Re: To Rename a field

upaliwije — Mon, 03 Mar 2014 04:41:14 GMT

Thanks

But It is not working as expected by. It does not show any dimension at all.

Re: To Rename a field

sebastiandperei — Mon, 03 Mar 2014 04:47:54 GMT

Hi. if you want to merge the AB to AA, and AC to CC, and the other to the same:

if(Dept='AB',

'AA',

if(Dept='AC',

'CC',

Dept)) as Dept

Re: To Rename a field

amit_saini — Mon, 03 Mar 2014 04:50:45 GMT

Hi Upali,

Could you please share your data.

Thanks,

Re: To Rename a field

chiru_thota — Mon, 03 Mar 2014 04:55:21 GMT

if(match(Dept,'AB','AA'),'AA',if(match(Dept,'AC','CC'),'CC',Dept)) as Dept2

Re: To Rename a field

upaliwije — Mon, 03 Mar 2014 04:55:41 GMT

Thanks a lot