Dupes not showing on the table box

[Anonymous]

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

[qlikmsg4u · Accepted solution]

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];

[Anonymous]

It works. Thank You!

Frank