Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

BasicTable incorrectly highlighted the entire columns instead of individual cells.

vicloo
7 - Meteor

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 resultActual result

Expected row to be highlighted, see brackets below:

ExpectedExpectedlighted:

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

 

A Col2 ruleA Col2 rule

 

 

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

 

Thanks,

 

 

2 REPLIES 2
JohnR
7 - 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

vicloo
7 - Meteor

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