Skip to main content

I am a new user trying to split out TRUE FALSE values contained in column Web with the TestFilter, but can't seem to hit on the correct Test Condition. Each time I Run Translation everything goes through to Unfiltered. It would appear that the TestFilter isn't recognising Alpha characters.

When I change alpha TRUE to numeric 1 then the TestFilter works fine.

 

This doesn't help when I have Alpha Numeric values such as 06HaaR.

I would value assistance in this regard please.

Cheers

Hi,

I think, Web column have formula instead of value.

Connect the reader to inspector and see the contents of web column initially. Later pass the respective value instead of "FALSE"

Pratap


Hi,

I think, Web column have formula instead of value.

Connect the reader to inspector and see the contents of web column initially. Later pass the respective value instead of "FALSE"

Pratap

All cells contain values and no formulas

 

 


Can you send sample data of the 2018-07-27-14-14-32.png to review and suggest


All cells contain values and no formulas

 

 

Sample data is required to check... this is something strange than expected.

 

 


As I said, "I am a new user" and am feeling my way and don't understand a lot of the terminology.

After playing around with the parameters with a bit of trial and error, I have stumbled onto the answer.

The operator field needs to be set to Contains Regex.

My issue appears to be resolved. Cheers


As I said, "I am a new user" and am feeling my way and don't understand a lot of the terminology.

After playing around with the parameters with a bit of trial and error, I have stumbled onto the answer.

The operator field needs to be set to Contains Regex.

My issue appears to be resolved. Cheers

It's likely that there are hidden/non printing characters in your column which is why the equals condition isn't working

 


Reply