topic How to add one more column by Transformation in QlikView

How to add one more column by Transformation

Thu, 15 Nov 2012 05:50:59 GMT

I am uploaded a .xlsx file in Qlikview having to feilds Doc Id and Tags2.

LOAD [Doc Id],

Tags2

I wani to call one more feild as S.No which must contains numbers 1,2,3......etc so that i can reach to state mentiones below:

LOAD [Doc Id],

Tags2,

S.No

Can anybody help me how to Create this one more feild S.No. with the help of transformation through Tablefiles.

Re: How to add one more column by Transformation

jagan — Thu, 15 Nov 2012 08:10:18 GMT

Hi,

Try

LOAD [Doc Id],

Tags2,

RowNo() AS S.No

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: How to add one more column by Transformation

its_anandrjs — Thu, 15 Nov 2012 08:31:44 GMT

Hi,

Load some thing like in your script

LOAD

[Doc Id],

Tags2,

RowNo() as S.No

from datasource.

HTH

Regards,

Anand

Re: How to add one more column by Transformation

Thu, 15 Nov 2012 08:40:40 GMT

Hi Anand

Actualy i am having two sheets one as Master having 3 fields as Doc Id, Tags1,S.No

whereas my second sheet having only two fields as Doc Id ,Tags2

I want to compare Tags1 (Master Sheet) with Tags2 (Answer Sheet)....Problem is that here primary key is Doc Id as exists in both the sheets .But i want to make S.No as Primary key....S.No exist in my Master sheet but not in Answer sheet....i want somehow to call S.No in answer sheet...Your mentioned solution is not working as already

LOAD

[Doc Id],

Tags2 are coming from my Answer sheet.

If i use

RowNo() AS S.No

FROM DataSource;

Than inside script two times From will exist...which is wrong ....Please help me if u have any other solution...

Re: How to add one more column by Transformation

its_anandrjs — Thu, 15 Nov 2012 10:01:08 GMT

Hi,

As i understand you have two tables

Table1:

Doc Id,

Tags1,

S.No

Table2:

Doc Id ,

Tags2

For this if you create a combination key in both the tables like

Table1:

Doc Id & Tags1 as Key

Table2:

Doc Id & Tags2 as Key

and then compares this keys.

HTH

Regards,

Anand

Re: How to add one more column by Transformation

Thu, 15 Nov 2012 10:03:46 GMT

Hi Anand

I got my results by implementing

RowNo() as S.No

Thanks buddy..!!!