Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Articolo | Descrizione | Num. | Forn. | Rag. Soc. | Doc. | Data | Qta |
610101NERO | PAMELA 610101- Mat. EL PASO - Col. NERO | 12B | 295 | GREENLAND INTERNATIONAL LIMITED | 13 | 40024 | 120 |
Hi,
I have this problem:
I load a table with records about shoes and i have for a record for example this situation :
I load the table :
tab2:
LOAD codart, desart, datacons_f, codfor_f, ragsoc_f, qta_f, coddoc_f, numdoc_f
FROM ordini_fornitori.xls (biff, embedded labels, table is ts4f5$, filters(
Remove(Row, Pos(Top, 1)),
Top(1, 'codart'),
Top(2, 'desart'),
Top(3, 'datacons_f'),
Top(4, 'codfor_f'),
Top(5, 'ragsoc_f'),
Top(6, 'qta_f'),
Top(7, 'coddoc_f'),
Top(8, 'numdoc_f'),
Top(9, 'variante')
));
and in the field qta_f i have the total pairs of shoes, while in the field variante i have the number of wrappings.
For Example :
|
Now i have to duplicate this record n times where n is qta_f/left(variante,2) and in every record i have to put in qta field left(variante,2)
Thanks
Sorry, but your table layout seems to have sent the post display a bit screwy...
Have you investigated AUTOGENERATE, and possibly FOR EACH... NEXT. As I am not sure why you might want to duplicate these records, it is difficult to be too constructive in my reply.
Is there another table involved? A join to additional data can provide a duplicated record view of your spreadsheet data in the way you want it.