Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Load some thing like in your script
LOAD
[Doc Id],
Tags2,
RowNo() as S.No
from datasource.
HTH
Regards,
Anand
Hi,
Try
LOAD [Doc Id],
Tags2,
RowNo() AS S.No
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
Hi,
Load some thing like in your script
LOAD
[Doc Id],
Tags2,
RowNo() as S.No
from datasource.
HTH
Regards,
Anand
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...
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
Hi Anand
I got my results by implementing
RowNo() as S.No
Thanks buddy..!!!