Replace Blank value in datatable with text

I want to replace blank value in data table with some Text value

Input is Input

Output should be output

Using Replace string i am able to replace blank value with no data and how it will reflect in main data table if we use append row blank row value will also be present

1 Like

Main.xaml (10.6 KB)
@ndivya

Use this workflow

Cheers

1 Like

Can’t open the Main.xaml. it has error Can you send once again

Hi @Himanshu.joshi
The number in this cell is formatted as text or preceded by an apostrophe .

how i can convert this to number ?

Thanks

You can convert to double by wrapping it with Cdbl(): Cdbl(YourStringHere)

where i can write this ? this my code

Thanks

Based on your screenshots, it looks to me that you are getting that error because you are trying to insert a numeric value into a string column in your datatable. If the data type is string you need to surround it in quotes so it’d be “0” instead of 0

1 Like

@Dave Thank you