topic TO SHOW DUPLICATE DATA in QlikView

TO SHOW DUPLICATE DATA

Fri, 29 Jul 2011 12:41:24 GMT

Hi,

While loading below files, I want to have duplicate data also from below file.

Let me know what code should I enter.

Last two rows are having duplicate data.

Invoice NO	Customer ID	Product	Qty	Price	TOTAL
M001	CUST001	ABC	10	100.00	1000.00
M002	CUST003	DEF	20	200.00	4000.00
M003	CUST002	GHI	30	250.00	7500.00
M003	CUST002	DEF	10	200.00	2000.00
M004	CUST005	ABC	20	100.00	2000.00
M004	CUST005	ABC	20	100.00	2000.00

Thansk & Regards,

Manish

TO SHOW DUPLICATE DATA

erichshiino — Fri, 29 Jul 2011 14:05:17 GMT

Hi, Manish

You need to include a field to have a difference in your rows

On the load statement, you can include something like this:

LOAD FIELD1, FIELD2, rowno() as ID

from / Resident .... ETC

After this, if you want your data exactly like this, you can include those fields in a straight table and hide the ID and some expression to have only the columns that you need (Straight table properties -> Presentation -> Hide column)

Hope this helps,

Erich

TO SHOW DUPLICATE DATA

Fri, 29 Jul 2011 14:12:52 GMT

Thanks Erich, It's working!!!