Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

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
Author

Thanks Erich, It's working!!!