BasicTable incorrectly highlighted the entire columns instead of individual cells.

[vicloo]

Hi everyone,

The Basic Table tool has incorrectly highlighted the entire columns (A Col2,ACol3, B Col2, BCol3) instead of individual cells (see brackets in the expected result image) below.

The workflow compares two sources and produce a data comparison output.

The actual result is shown below:

Actual result

Expected row to be highlighted, see brackets below:

Expectedlighted:

The Column rule for "A Col2" is as per below:

A Col2 rule

Please note: Data type for "A Col2" and "B Col2" is V_string as per attached files.

Thanks,

[JohnR · Accepted solution]

You are comparing your variable to a string literal "[BCOL2]" instead of the variable [BCOL2].

I suggest using the "Formula" option instead of the the "When" option and using the exprerssion [ACOL2] != [BCOL2]

[vicloo]

Thanks for the solution. It's now working for me. 

Nevertheless, I find it strange that the "When" field accepts double data type as variable in "B Col1", but not V_string in "B Col2".