Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to add one more column by Transformation

Hi

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.

1 Solution

Accepted Solutions

Re: How to add one more column by Transformation

Hi,

Load some thing like in your script

LOAD

[Doc Id],

Tags2,

RowNo() as  S.No

from datasource.

HTH

Regards,

Anand

5 Replies
MVP & Luminary
MVP & Luminary

Re: How to add one more column by Transformation

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

Hi,

Load some thing like in your script

LOAD

[Doc Id],

Tags2,

RowNo() as  S.No

from datasource.

HTH

Regards,

Anand

Not applicable

Re: How to add one more column by Transformation

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

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




Not applicable

Re: How to add one more column by Transformation

Hi Anand

I got my results by implementing

RowNo() as  S.No 

Thanks buddy..!!!