Hi, I'm using excel component to load the merge cell. But the empty values are getting replaces with null values. I want to replace the empty values with the top first value of merged cell. Can you please help on this

[saggy_sf]

Before loading excel file:

after loading:

 

 

I don’t want any null values. I there any way to handle this in excel component.

[ganesh_pitchai]

Hi @saggy_sf​ I don't know what mode are you using , If you use the advanced mode you can write a sql query whatever you want apply case and replace the null values to top value.

[saggy_sf]

Thank you I got it.. I have used row number with Last value and achieved it.