Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

TO SHOW DUPLICATE DATA

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 NOCustomer IDProductQtyPriceTOTAL
M001CUST001ABC10100.001000.00
M002CUST003DEF20200.004000.00
M003CUST002GHI30250.007500.00
M003CUST002DEF10200.002000.00
M004CUST005ABC20100.002000.00
M004CUST005ABC20100.002000.00

Thansk & Regards,

Manish

1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

TO SHOW DUPLICATE DATA

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

2 Replies
erich_shiino
Honored Contributor

TO SHOW DUPLICATE DATA

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

Not applicable

TO SHOW DUPLICATE DATA

Thanks Erich, It's working!!!

Community Browser