Using data type Nullable correctly

[mangogul (Christoph)]

Dear colleagues,
I have a variable whose value can be a decimal value, 0, or it can be empty.
Which data type am I supposed to use?
“Nullable” renders conversion errors, see the picture.

[balupad14 (Balamurugan)]

Hello @mangogul,

You can use the double value for the Nullable as below.

Sample File : mangogul.zip (2.1 KB)

Regards
Balamurugan.S

[mangogul (Christoph)]

Hi Balamurugan,

many thanks! Unfortunately, I run into another issue when I try to add a corresponding column in my DT, see the picture.

Do you have a solution for this one, too?

Thanks in advance
Christoph

Ranking_beiidentischenWerten.xaml (17.2 KB)

@balupad14

Balamurugan

[balupad14 (Balamurugan)]

Hi @mangogul,

Below I have shown you to allow null in the double datatype of column.

The green arrow shows that you are allowing the null to the column.

You can verify the value like below.

Sample : mangogul.zip (2.9 KB)

Regards
Balamurugan.S

[mangogul (Christoph)]

Hi Balamurugan,

thanks for your inexhaustible patience! – Nor for the next issue:

I have a try/catch sequence in which I want to assign “Nothing” if the workflow can’t scrape a data item. How do I assign it to the data table?

I get the following message:

mangogul2.zip (11.2 KB)

–

I can answer myself (to whom it may concern): The solution isn’t “vNullable = Nothing” but rather “vNullable = Dbnull.Value”