View Single Post
 
Old 07-07-2023, 01:27 AM
Taka Taka is offline Windows 10 Office 2007
Novice
 
Join Date: Jul 2023
Posts: 1
Taka is on a distinguished road
Default sorry I would like to reopen this topic, I can't get it to work

I have my data file with the following records:

Lineas;Nombre;Articulo
2;Jose;Plantas
1;Juan;Verduras
1;manuel; carne


and i want to get this result

2;Jose;Plantas
2;Jose;Plantas
1;Juan;Verduras
1;manuel; carne


I have used the combination fields, to obtain a normal combination of them, but I cannot get the macro to work, and the corresponding code.

I have modified the values ​​FIRST_NAME for Nombre, LAST_NAME for Articulo and Quantity for Lineas, and nothing.



I have
Quote:
IF{MERGEREC}= 1 {SET Idx 0}}{IF{Idx}<> {MERGEREC} "{SET Data "{MERGEFIELD Nombre} {MERGEFIELD Articulo}"}{SET QTY {MERGEFIELD Lineas}}{SET Idx {MERGEREC}}"}{SET QTY {=QTY-1}}{REF DATA}{NEXTIF {QTY}= 0
tried before, after the field label, instead of the label, and I don't see how it is, nor have I found more information elsewhere.


Thanks for your help
Attached Files
File Type: xlsx Datos.xlsx (8.7 KB, 5 views)
File Type: docx Sample.docx (14.4 KB, 6 views)

Last edited by Taka; 07-07-2023 at 01:29 AM. Reason: Dont write Thanks
Reply With Quote