topic Re: Load two o more equal rows in QlikView

Load two o more equal rows

Wed, 02 Apr 2014 14:35:26 GMT

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.

Re: Load two o more equal rows

its_anandrjs — Wed, 02 Apr 2014 14:37:52 GMT

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

Hope this helps

Re: Load two o more equal rows

alexandros17 — Wed, 02 Apr 2014 14:38:06 GMT

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

Re: Load two o more equal rows

Wed, 02 Apr 2014 14:46:11 GMT

How to make a flag?

Re: Load two o more equal rows

its_anandrjs — Wed, 02 Apr 2014 14:46:20 GMT

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

Re: Load two o more equal rows

MK_QSL — Wed, 02 Apr 2014 14:46:31 GMT

add one more line to the table script...

Load

RowNo() as NO,

Field1,

Field2..

....

From Tablename;

Re: Load two o more equal rows

Wed, 02 Apr 2014 14:47:18 GMT

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

Re: Load two o more equal rows

its_anandrjs — Wed, 02 Apr 2014 14:51:02 GMT

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;

Re: Load two o more equal rows

its_anandrjs — Wed, 02 Apr 2014 14:54:52 GMT

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