Cannot find excel column when using Filter activity

Help StudioX
,
1

Hi, I’m trying to use Filter activity inside Excel source, all the columns doesn’t have header so I just used Column number: AW as filter. But when running the robot says it cannot find the column. Does anyone know what could have caused this? Thanks!

image
image1147×405 20.7 KB

image
image878×399 12.6 KB

2

I believe when you use column number, it’s looking for the actual count where Column A would be 0. z would be 25, so try 48

3

depends on how your excel is set up - Try Column0 for the first column. Sometimes it will come across as Column1. Then count across to the Column you wish

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.