Data table activities

Help
1

OuputDt.select(“age<‘20’&&class>‘5’&&city.contains(e)”).CopydataTable
now tell me where i did mistake
the error is missing operand before &&
to make the above conditins true and want to get output based on this conditions

2

@tuttu

Use AND instead of &&

And also put single quotes properly.

3

again getting error in city.contains(e) is it correct expression to get the output

4

@tuttu

Here ‘e’ is what kind of variable ?

5

@tuttu

OutputDt.asenumrable.where(function(x) cint(x(“age”)) <20 andalso cin(x(“class”)) >5 andalso x(“city”).tostring.tolower.contains(“e”) ).copytodatatable

6

i didnt declared anything about it.want to declare to use it…

7

tell me the expression to get the output that city which contains “E” chracter and what variable type we have to give for “e”

8

@tuttu,

Are you trying to filter City column contains ‘e’ or what ?

If yes then try like this:

OuputDt.select(“age < 20 AND class > 5 AND city like ‘%e%’”).CopydataTable

9

i got it sir thank you…
sir can you please tell me find and delete the duplicate rows in data table

1 Like
10

Hi @tuttu

in the above expression “city.Contains(e)” , if we are using Contains in any expressions the target should be the type boolean and most times it used in if conditions,
Note: First you should convert any datatype to String and then you should use Contains because Contains comes under String type,
Please refer the following program:
dtConditions.xaml (6.7 KB)
new.xlsx (7.8 KB)

Thanks.
Goutham Vijay

11

@tuttu

The following expression will delete duplicate records from given Data Table.

Datatablename.DefaultView.ToTable(True,“Column1”,“Column2”,…). CopyToDataTable

12

thank u goutham for your reference

13

if we want to sort more than columns in a sort data table activity which expression we want to write
and also tell me how to generate and lookup data acivities

14

more than two columns

15

how can we do
get time span fields
parse date
get elapsed days &time activities
tell me the expressions for it