Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

Hi,

Load some thing like in your script

LOAD

[Doc Id],

Tags2,

RowNo() as  S.No

from datasource.

HTH

Regards,

Anand

View solution in original post

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try

LOAD [Doc Id],

     Tags2,

    RowNo() AS S.No

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

its_anandrjs

Hi,

Load some thing like in your script

LOAD

[Doc Id],

Tags2,

RowNo() as  S.No

from datasource.

HTH

Regards,

Anand

Not applicable
Author

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...

its_anandrjs

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
Author

Hi Anand

I got my results by implementing

RowNo() as  S.No 

Thanks buddy..!!!