Is it possible to get integers using READ RANGE activity?

Help
1

Hello everybody,

I cannot repeate the exercise from the 3rd lesson of Foundation training. In the video the file “Employees300 orig.xlsx” is read and then data table gets filtered by the condition “Age < 30”.

If I try to do this, the condition doesn’t work: no rows stay in the table if I set “keep rows” and the condition.

Read_range_not_integer
Read_range_not_integer1106×1065 88.7 KB

What do I do wrong? This column in data table has type System.Double.
Thank you in advance!

2

Hello @dapachev

Have a look at this sample

Main.xaml (9.6 KB)

Test.xlsx (8.2 KB)

The problem in your case might be that you are using the same datatable as input and output.

Thanks,
Prankur

1 Like
3

Hello @PrankurJoshi,

Thank you for your responce.
I tried both: the dame data table and another one as output: non has worked. And in the video in the training the same data table is used.

The file Main.xaml confuses me: I cannot find there something about reading excel files. Where schould I look at?

4

Here we have read excel sheet

image

5

Hi @PrankurJoshi,

The file which you uploaded looks so:

Main
Main1442×1046 88 KB

I cannot find Excel Application Scope activity there. Is it a wrong file or I’m looking at the wrong places?

6

Ohh my bad use this

Main.xaml (9.6 KB)

1 Like
7

Thank you @PrankurJoshi,
Due to server error the files cannot be downloaded now. I’ll check the file later.

1 Like
8

Hi @PrankurJoshi,

Your script works by me not properly either.

DT_filter_do_not_function
DT_filter_do_not_function735×838 46.8 KB

It looks like my local problem. I address tech support then und delete this thread.
Thank you for your help!

1 Like