Data table separated by values

Help Studio
, ,
1

Hi everyone,

I try to separate a data table by values from a column. I have the “Tipo Cambio” column with diferent values and I try to get the values for each “Tipo de Cambio”. The column “Tipo de Cambio” is dynamic so I can´t use the value inside to filtered.

image

Can anybody help me ??

2

What does this mean? Get them how? To use them for what?

Did you Read Range the spreadsheet into a datatable? If so then you can For Each Row in Data Table to get the data for each row, and it would be CurrentRow(“Tipo Cambio”).ToString to get that column’s value.

3

Yeah tnks let me try, I’ve already had the table in a DataTable variable

4

Looks Like a group by case

5

Hi @marquezd

  1. Use the “Read Range” activity (value=dt)

DistinctValues = dt.DefaultView.ToTable(True, “Tipo de Cambio”)

For Each row In DistinctValues.Rows
FilteredDataTable = dt.Select(“Tipo de Cambio = '” & row(“Tipo de Cambio”).ToString & “'”).CopyToDataTable
’ Process the filtered DataTable as needed (e.g., write it to a separate file)

Hope this helps

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.