Duplicate rows from a xls table\

massimo6919 — Wed, 13 May 2009 17:15:38 GMT

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 :

codart	desart	variante	codfor_f	ragsoc_f	numdoc_f		Qta
610101NERO	PAMELA 610101- Mat. EL PASO - Col. NERO	12B	295	GREENLAND INTERNATIONAL	13		120

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

Duplicate rows from a xls table\

Wed, 13 May 2009 18:18:06 GMT

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.

topic Duplicate rows from a xls table\ in QlikView

Duplicate rows from a xls table\

Duplicate rows from a xls table\