Filter Data Table with a variable

Help Studio
, ,
1

I’m trying to build this project where For Each Excel Row in my input Excel, Sheet1, Range A:A, it reads and stores the cell value in a variable called currency. Then I extract a data table from an exchange currency website and I want to filter it so only one row remains, the one containing said currency with its buy and sell values. After that I write the filtered data table in an output Excel file. But the filtering doesn’t work for some reason and it says it can’t write the filtered data table because it has no rows or columns. The first currency is USD, when I try with “Currency” (the column name on that website) = “USD” it works just fine, but when I try with “Currency” = currency it just doesn’t. And yes, it does read the currency value in the input Excel just fine, I checked that as well with a message box. What could be the issue here? I even tried with .ToString and it doesn’t work either. Thank you!

2

@Wolf214356,

Is it possible to share screenshot how you implemented it.

3

This is just a part of the code. In the first part I built a header for the table in the output file. All of the code is inside the Use Excel file output as “Excel” which is all inside an Excel Process Scope. “Excel2” is the input file I’m reading the values from.

1
1595×378 10.1 KB

2
2436×452 19.3 KB

The image shows a workflow process that involves extracting table data from a web source, filtering the data, and then writing the filtered data into an Excel sheet. (Captioned by AI)
The image shows a workflow process that involves extracting table data from a web source, filtering the data, and then writing the filtered data into an Excel sheet. (Captioned by AI)364×410 17.3 KB

4

@Wolf214356,

Instead of = symbol can you try Contains?

5

Sorry, forgot to mention I already tried that and still nothing.

6

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