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
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.
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,