Filtering Data in Uipath studio

[BigDee (Deon)]

@Palaniyappan Thank You for assisting me buddy. The file disappears after execution i don’t know why. I don’t know why.

[Palaniyappan (Forum Leader)]

it looks like some CSV file
did you use any move file or copy file activity along the workflow that changes the file format
Cheers @BigDee

[BigDee (Deon)]

@Palaniyappan Nope. i don’t know what happening. Everything looks fine on the workflow. Maybe i put final_dt in the wrong place somewhere.

[Palaniyappan (Forum Leader)]

No worries can i have a view on your complete xaml if possible
Cheers @BigDee

[BigDee (Deon)]

These are all the screenshot of my workflow. @Palaniyappan

[Palaniyappan (Forum Leader)]

Keep write csv outside the for each row loop (next to for each row loop )
Buddy @BigDee

[BigDee (Deon)]

@Palaniyappan it worked but i only got the column names.

[Palaniyappan (Forum Leader)]

Fine
Kindly check whether filter condition is given correctly with the value…and also check whether we are getting data after extracting
We can check that by a write line Activity, before filter datatable Activity like this
Out_dt.Rows.Count.ToString
Check what js the output in output panel
– after filter datatable use same write line Activity to check the number of rows in Final_dt
Like this
Final_dt.Rows.Count.ToString

If both the values are more than 0 then we are fine…lets check that buddy
Cheers @BigDee

[BigDee (Deon)]

@Palaniyappan this is the output i get.

[Palaniyappan (Forum Leader)]

So that value 0 comes after filter datatable right…check with the condition once buddy… especially the value assigned to that condition must matvh with the value in your excel

Cheers @BigDee

[BigDee (Deon)]

@Palaniyappan This is value assigned. and the one in excel.

[Palaniyappan (Forum Leader)]

i would like to the extracted datatable, this excel has no data right buddy
so we want to check with the value in the datatable extracted from the webpage
Sorry for the inconvenience
but we need to know all those stuffs to get this done
Fine to know that
–once after extract datatable activity use a output datatable activity and pass the variable out_dt as input and get the output as a string variable named out_text
–use a write line activity and pass the variable out_text as input
we can see the output in the output panel
Then we check whether the condition in the filter wizard applied is correct or not
Cheers @BigDee

[BigDee (Deon)]

@Palaniyappan no probs buddy.

this is the extracted datatable.

[Palaniyappan (Forum Leader)]

Yah here it will come…we need to check this gets to studio
Thats why after extracting i suggested to display that in output with output datatable and writeline Activity
Cheers @BigDee

[BigDee (Deon)]

hey buddy i’m getting an error !

… @Palaniyappan

[Palaniyappan (Forum Leader)]

create a variable of name out_text with string type in variable pane
Cheers @BigDee

[BigDee (Deon)]

@Palaniyappan in Write activity i should write out_text.

[Palaniyappan (Forum Leader)]

yes @BigDee

[BigDee (Deon)]

@Palaniyappan

This what i’m getting.

[BigDee (Deon)]

if i put out_text on the write line under filter datatable i get the output, but when run the program it gives me this output.

only column names without the expected filtered data.