topic Re: Dupes not showing on the table box in QlikView

Dupes not showing on the table box

Anonymous — Thu, 16 Jul 2015 16:45:53 GMT

Hi All,

I need help to display a dupe record on the table box. In my current process i loaded my data from an excel file, where i have 2 records with same data that i want it to display on the table. Somehow only showing once. Please help.

Company	ID	Date 1	Activity	Type	Date 2	Amount
ABC	99990888	4/13/2011	Fee	Misc	4/13/2011	-100.50
ABC	99990888	4/13/2011	Fee	Misc	4/13/2011	-100.50

Many Thanks,

Frank

Re: Dupes not showing on the table box

qlikmsg4u — Thu, 16 Jul 2015 16:57:37 GMT

HI Frankie,

Add RowNo() in script that will solve your problem.

ex:

load*,RowNo() as RowNo;

load * Inline [

A,B,C

1,2,3

1,2,3];

Re: Dupes not showing on the table box

Anonymous — Thu, 16 Jul 2015 18:18:15 GMT

It works. Thank You!

Frank