Reading one cell in a table and comparing it to another in the same row

Ignition
,
1

I have a table which is pulling a db table to it, I need to look at column B and if it has a 1 make column A red what would be the best way to do this within the table

2

You need to use script transform in your query binding and compare the values on each column and assign background color depending on it.
You can find few examples here.

3

This a common question for Vision users switching to Perspective. A fundamental difference between their table implementations is that Perspective requires you to embed cell styling within the table data (as nested mappings) while Vision requires you to supply styling external to the data via separate configuration and/or special method calls.

This paradigm extends nearly everywhere in comparisons between Perspective components and Vision components.