Problem Variable

[Rico_Rico]

Hi @armingrudd how are you? I hope well.
I send you another question if you can answer me pls: when i set a Variable Value with “Table Column to Variable node” and the Variable Value could be unknown in same case, how i can bypass “unknown error message” of the Variable? in this case in photo attached “Variable Row20”.

thankx for help me

@umberto75 in CC:

[armingrudd]

Hi @Rico_Rico,

Unlike the Table Row to Variable where the node can handle missing values, the Table Ciolumn to Variable skip them by default (or fail in case of missing values based on the configuraiton).

So, you can handle missing values beforehand by using a Missing Value node. e.g. in case of numbers (double) give them “NaN” or for strings “missing”, and then convert them to variables.

[Rico_Rico]

thenkx, i test it! See u later to news

[Rico_Rico]

good morning @armingrudd, i test and test more solution but, i haven’ t the solution. Maybe i explained my need badly. I mast check “unknow” varible and and i’m starting to think that it can’t be done. Can you please, a good solution to me?

@umberto75

Thankx

[MartinDDDD]

So it is not testing if a specific flow variable has a “missing value”, but to test if a variable “Row20” exists?

Maybe take a look at this solution:

Check if flow variable exists - Part 2

I just realized something. Since we’re using Variable Expressions already, and that Variable Expressions does not point directly to a variable, but rather retrieves the values of a variable via the variable() function, we can do all the if operations in the Variable Expressions directly without any issue. The workflow becomes as simple as this: [image] As usual, I create 2 scenarios: [image] And we get the same results as before - we’re using the same logic, just doing everything via the Va…

[ActionAndi]

Hi,
as you meantioned, that you create this variable “Row20” from a table it would be maybe a good way to use the “empty table switch” before turning it into a variable “Row20”.

In general I would avoid using a generic name like “Row20” for a variable name.

[Rico_Rico]

i will not know if the row is know or not know before! i wish make in “column expression” the check it after

[ActionAndi]

Is it possible to share your workflow? Otherwise its quite hard to help you.

For me it seems that you have a “row filter” or similar prior to the “table row to variable” node, or?
So depending on the input data, the output of the “row filter” changes. As a workaround you can reset the RowID using the “RowID” node.

[Rico_Rico]

thank you @ActionAndi . i share to you a cut of workflow

@umberto75

[ActionAndi]

What comes out of Node 808? I think it would better to use a Table Row to Variable Node but lets check the input.

[Rico_Rico]

the node 808, filters only same items in column. The items after they become Variables but, the rows variables/items may change depending on the file input. so, i don t know the correct range of the varaibles before. The variabels rows, gruop by more output different output blocks

[Rico_Rico]

Hi everyone, I found the solution to my need! I “doped” the variables, joining them with the “Catch Error Var Ports” node so that those which are unknown have the “X” character as their interceptor in this case:

I share it to caring.

Thank u @armingrudd
out put Variables KNOW and UNKNOW

thanks we to collaboration: @armingrudd , @ActionAndi , @MartinDDDD, @umberto75 and @Iris for the shared post inspired me

try-catch - why is the variable missing outside?

Variables created inside a try catch will stay in this space. In your lower example you did connect the String configuration to the catch node. This will forward the variable, but you cannot decide in the try catch which which variables are generated and which not. However variables created before the try node can be changed inside the try catch. If you change your workflow as below, you will see that the variable nodes work similarly to the table nodes. [image]