Linq Query to Replace empty value from a column with a constant value

Hi

Can you help me with Linq Query.

if column2 from my datatable has null or empty value then i need to fill it with 100.

Hi @JITU99

Please check below thread

Regards,

@JITU99

Another approach

By using excel activities

Use Find/Replace Value activity

Where to search: Excel.Sheet(“Sheet1”). Range(“B:B”)

Value to find: String.Empty

Replace with: “100”

Regards,