Filter datatable in specific format

Help Studio
, ,
1

Hi All,
today’s query is to filter datatable in specific format.
here I am attached excel file with input and output sheet.

i have to filter input sheet based on “Not working”
after that I have to create a table (Shown in output sheet) in mail body .

please help
Dummy.xlsx (10.5 KB)

3

@Lakshya_Garg2
For that you can directly use for each row inside that use for each column
and use if CurrentRow(Column.columnname).tostring= “Working”
replace it with “” else should be empty. this may solve your que

image
image733×613 22.6 KB

stion

4

@Lakshya_Garg2

Use a filter datatable activity to filter the table…in the configure give column name and equals …and then on right "not working”

Or you can use assign activity with linq

Dt = dt.AsEnumerable.Where(function(x) x("ColumnName").ToString.ToLower.Trim.Equals("not working")).CopyToDataTable

To create a table in mail body you can use create html content activity and pass the datatatble directly

Hope this helps

Cheers

5

Hi @Lakshya_Garg2

Give a try to this.
Sequence3.xaml (8.6 KB)

Output
Dummy.xlsx (11.4 KB)

Hope this helps.

8

hi,

can u please share workflow of this