Dear One Data Community,
I would like to display a set of column names within an error message in an assert processor. I am just wondering how that can be done?
So far, I have been trying to do that with workflow variables, but I have not managed to get that working yet.
In an SQL Query processor I have the following SQL statements
SELECT distinct f.col_name as unexpected_columns FROM firstInputTable as f WHERE f.col_name NOT in (SELECT s.origin_column_name from secondInputTable as s)
At a later step, I would then like to display the
unexpected_columns within an assert’s error message.
Is there any way to do that, like by setting the
unexpected_columns as a value of a workflow variable and then embedding the workflow variable within the assert error using the ‘@global_variable_name@’ syntax?