Load two o more equal rows

[#1]

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.

[its_anandrjs]

Give a flag field for the row on load script then your are able to load this rows.

Hope this helps

[alexandros17]

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

[#4]

How to make a flag?

[its_anandrjs]

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

[MK_QSL · Accepted solution]

add one more line to the table script...

Load

     RowNo() as NO,

     Field1,

     Field2..

....

From Tablename;

[#7]

I did autonomber(field) and I have a new field but not all rows

[its_anandrjs]

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;

[its_anandrjs]

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