Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Erich, It's working!!!