Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

What do the red triangles mean?

In some contexts, like when setting the values of Environment Variables...or setting the Output Columns of a Join component...red triangles appear in the top-right corners of some of the fields that I modify.

If you're familiar with Excel, it looks very similar to the indicator that a cell has a comment, in an Excel spreadsheet.

What is the meaning of these red triangles, in Matillion?

Thanks!

4 Community Answers

Kevin Havice —

Oops, I mean the red triangle appears in the top-LEFT corner of the field.

(It's in Excel where the comment indicator appears in the top-right of the cell!)


Matillion Agent  

Ian Funnell —

Hi Kevin,

This usually means that the field is not valid for some reason, but can also just be an indicator that something was changed.
You’ll see it if a mandatory value is missing (e.g. if an Output Column in a join component is not given a name), or (temporarily) if an Output Column’s name has been changed.

If there is an error which makes the component itself fail to validate, you’ll see the component’s border turn red. There will also be an accompanying error message in the Properties of the component which should help explain the error.

Best regards,
Ian


Kevin Havice —

Got it. Still, I think it's ambiguous.

Personally, I think it's useful to indicate errors. But I don't want an indicator to say that something has changed.

Or, if it is necessary to keep an indicator to show that something changed, then I think that should be different from the error indicator. Maybe have the red triangle mean "error," but to show that something has changed, make it a different color? Like a blue triangle?


Matillion Agent  

Ian Funnell —

Hi Kevin,

Yes, I agree that it can be a little confusing. The grids are generic HTML5 components, and their main aim is to highlight changes. We also have some validation on top of that in case of parse errors.

The best way to check for errors is by looking at the main component Properties, and the outline of the component on the canvas. When all is good, you should get a row of green OK’s and a green border on the component.

Best regards,
Ian

Post Your Community Answer

To add an answer please login