Store data when reading

studio

#1

Hello friends,

I am new to the tool and right now I am doing a data reading and I want to store them in a variable as I read the data.

You can support me with this little detail that I have, I already do the reading but I need to store them and save them in a variable.

Thanks for your time…

Annex to the reading process …ejemplo_forum.zip (13.5 KB)


#2

Parece que hablas español… en la ventana de settings en la opción output, usa ctrl + K, de esa forma creas las variables.

Así te quedará asignada.

Saludos.


#3

gracias beesheep por tu comentarios, ya realice la creacion de la variable, lo que trato de hacer ahora es que dentro del FOR este leyendo los datos sin embargo cada vez que lea que se almacene en alguna variable por, y al final q me muestre todos los datos que leyo…

gracias y saludos!!


#4

Que tal @rhg_83 ?

Me podes subir fotos o tu xaml? asi va a ser más facil ayudarte.

saludos.


#5

Gracias @beeshep,

adjunto el .xaml, ahorita lo que realiza estar leyendo celda por celda en la columna “L” y que hasta donde encuntre en espacio en blanco de esos 5 documentos que leyo los almacene en alguna variable ya que esos q encontro los voy a llevar a otro archivo de excel y posteriormente que siga leyendo y almacenando en esa variable hasta donde encuentre datos.

espero me puedas orientar

gracias y saludos!!base de datos2.zip (15.1 KB)


#6

Hello rhg_83,

not really sure to have understood the need… :slight_smile:
Could you please translate your last message so that I might try to help ? :slight_smile:

Best regards,
Mustafa


#7

hello @mustafa.altinbasak , what I try to do is save me in groups in a variable, for example in column L the first 5 documents and in another variable the amount that is in yellow and that you continue reading if you find another group of documents.

thanks for your help and time

for example:
1900005724
1900012616
1900016524
1900017644
1900020124

1900024246

1900004237
1900008254


#8

Hello @rhg_83,

is this what you want ? (please toggle breakpoint and watch the value of “dictionary”).

ejemplo.xaml (13.8 KB)

You will need the Dictionary class which allows you to “link” a key (your importe) to a value (your documento).
Since we have a list of documentos to associate with an importe, we will use a Dictionary(Of Integer, List(Of Integer))
The Dictionary is getting populated with an importe and a list of documentos everytime a cell in “Documento” column is empty.

Please note that :

  1. I had to move your Excel file’s column up so that the first row is not empty.

ejemplo.xlsx (10.7 KB)

  1. You will need the Microsoft.Activities.Extensions package if you want the process to work (this package will allow you to add items to dictionaries)

Best regards ! :wink:
Mustafa


#9

thanks for the support is what I require, but as I show the result of the data?


#10

It depends on what you mean by “showing” it :stuck_out_tongue:


#11

thanks for the support is what I require…