community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

BasicTable incorrectly highlighted the entire columns instead of individual cells.

Meteoroid

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:

 

issue0001_actual.pngActual result

Expected row to be highlighted, see brackets below:

issue0001_expected.pngExpectedlighted:

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

 

issue0001_A col2 rule.pngA Col2 rule

 

 

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

 

Thanks,

 

 

Meteor

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]styling.png

Meteoroid

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".  issue0001_A col1 rule.png 

Labels