Skip to main content
Known Participant
May 10, 2023
Question

Combinación de datos - Carga de variables - Data Combination - Variables Loading

  • May 10, 2023
  • 1 reply
  • 1204 views

Hola comunidad.

Tengo que hacer un documento de 180 hojas. 

Cada hoja tiene 4 variables. 

Sin embargo, no es posible generar una hoja maestra y que las variables se actualicen 180 veces, ya que cada hoja tiene un diseño particular, no son iguales.

Entonces, debo colocar manualmente en cada una de las 180 hojas las 4 variables por cada caso. 

Así en la hoja 1 colocaré

V1 (varible 1), M1 (variable 2), A1 (variable 3) y  X1 (variable 4).

En la hoja 2 colocaré

 

-------------------------------------------------

Hi community,

I have to create a 180-page document.

Each page has 4 variables.

However, it's not possible to generate a master page where the variables update 180 times because each page has a particular design and they are not the same.

So, I have to manually input the 4 variables for each case on each of the 180 pages.

For example, on page 1, I'll input:

V1 (variable 1), M1 (variable 2), A1 (variable 3), and X1 (variable 4).

On page 2, I'll input:

V2 (variable 1), M2 (variable 2), A2 (variable 3), and X2 (variable 4).

Is there any way to do this without doing it manually?

Thank you very much!

V2 (varible 1), M2 (variable 2), A2 (variable 3) y  X2 (variable 4).

Hay alguna forma de realizarlo, sin que sea manualmente? 

Muchas gracias!

 

This topic has been closed for replies.

1 reply

Loic.Aigon
Legend
May 11, 2023

Can you provide screenshot of expected result? Not sure I get it.

Quima01Author
Known Participant
May 11, 2023

Sure, Here I attach a photo of two pages as an example. As you can see, the structure of both is different. What I highlighted in color are the data that come from the variables. Previously, what I did was to place V1, V2, V3,... up to V9, and assemble the two sheets. When generating the combination, the sheets were repeated. But then it's a lot of work to place the calendars and other details that change according to the data. I thought it would be easier.😕😕"

Loic.Aigon
Legend
May 15, 2023

The shortest way I would see this is having threaded text frames on your template (ex: [29] > [Diciembre] > [Sabado]) with a paragraph styles set with keep options to next frame. 

Then you prepare a text file like:

29

Diciembre

Sabado

30…

And you import your text file inside the first frame. You will probably have some edits but most contents should be ok.