Runtime error in Filter

Help StudioX
, ,
1

Hi can anyone suggest me why i am getting this error. Sorry i am not able to fix it. :pensive:

image
image844×573 20.7 KB

2

Hi @vignesh.maruthappan

May be you have given something wrong in the Configure filter open that and share the screenshot.

3

image
image1026×496 32.8 KB

4

I think you have made a wrong sequence… @vignesh.maruthappan

Could you share your workflow, and give me more explanation what you want to do in the flow.

5

1.I am using a master excel file where i am filtering out the data using column “A” and "C"into a new sheet.(only completed from column c and pipe fitting and system pipe fitting from column A)
2.Renaming Headers to different name.
3.Filtering data according to the column B and saving it to a individual.csv file.

image
image942×761 10.4 KB

6

Hi, here’s a couple of things you might want to check:

  • You’re using a “minor of” operator for your 3rd filter, is that correct? Should it be “equal to” instead?
  • Your column C contains both text and numbers. What is the data type of that column in the DataTable?
7

.oops ya should be equal to
column c should contain completed and not completed…
let me run again.

image
image900×560 9.31 KB

One more clarification.
is there any comment to rename all column names in one command rather than assigning separately. Sorry on it since i am new to ui path
image

8

Hi @vignesh.maruthappan

Instead of tying it copy the Column name and Value from your excel and in the third filter one it Equal to (=)