Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I'm trying to load a table which has several registers exactly equals. Qlikview load them only once and I would need to load as many as they are. How could get this?
Thank you.
add one more line to the table script...
Load
RowNo() as NO,
Field1,
Field2..
....
From Tablename;
Give a flag field for the row on load script then your are able to load this rows.
Hope this helps
QlikView loads all the rows but shows only one because all data are equal. To see all rows use autonumber() (look at the help) and add this new field to the columns. Hope it helps
How to make a flag?
You have to load data like below there is 3 tables with same fields FieldA,FieldB just put Flag field in the tables
Tab1:
FieldA,FieldB,
'Tab1' as Flag
From Location;
tab2:
LOAD
FieldA,FieldB,
'Tab2' as Flag
From Location;
tab3:
FieldA,FieldB,
'Tab3' as Flag
From Location;
Hope this helps
add one more line to the table script...
Load
RowNo() as NO,
Field1,
Field2..
....
From Tablename;
I did autonomber(field) and I have a new field but not all rows
Check this out
Tab1:
FieldA,FieldB,
'Tab1' as Flag
From Location;
tab2:
LOAD
FieldA,FieldB,
'Tab2' as Flag
From Location;
tab3:
FieldA,FieldB,
'Tab3' as Flag
From Location;
You can use AutoNumberHash128 for number creation
tab1:
LOAD AutoNumberHash128(FieldA,FieldB) as field,FieldA,FieldB
From Location;
tab2:
LOAD AutoNumberHash128(FieldA,FieldB) as field,FieldA,FieldB
From Location;
tab3:
LOAD AutoNumberHash128(FieldA,FieldB) as field,FieldA,FieldB
From Location;
Another option for this