If value is not null

[mitul_choudhary]

Hi @Nithinkrishna @ermanoj3101 @kumar.varun2

Please help on this case in excel value is having 0 value but it’s showing null
Main.xaml (100.6 KB)
.

[Nithinkrishna]

Hey @mitul_choudhary

You mean the excel doesn’t have any rows ?

#nK

[mitul_choudhary]

Hey @Nithinkrishna

This is urgent

Just i want this part number in column V & Description should be in Column W.
Means both should be seperated like this:-

Please help with the code

[Nithinkrishna]

Please share excel …

[mitul_choudhary]

@Nithinkrishna please make it fast this is urgent
Thanks for understanding

[mitul_choudhary]

@Nithinkrishna is it done bro…?

[Nithinkrishna]

StringSplitIdDesc.zip (25.2 KB)

Hope this helps

Thanks
#nK

[mitul_choudhary]

@Nithinkrishna
It’s coming again

@Nithinkrishna pls help on this >>!!!

[Nithinkrishna]

Oh you don’t want that to be in description ok just a sec

[mitul_choudhary]

@Nithinkrishna
I want like this:_

@Nithinkrishna is it done bro…?

[Nithinkrishna]

Sorry My mistake

Please make this change

Add a space between quotes. When we do things fast this is what happens

#nK

[mitul_choudhary]

@Nithinkrishna

[Nithinkrishna]

Are you running with any empty values ?

[mitul_choudhary]

@Nithinkrishna leave that while
running bot this is coming

@Nithinkrishna this is urgent
@Nithinkrishna r u there…?

[Nithinkrishna]

There should be some excel issue may be corrupted or too much of data. Try with new sheet please.

[mitul_choudhary]

@Nithinkrishna Please help on this bro.!!

[Nithinkrishna]

Hey @mitul_choudhary

This should not be a code issue I guess

Have your tried with different files

[mitul_choudhary]

@Nithinkrishna yes from other it’s working fine

[AkshaySandhu (AkshaySingh Sandhu)]

issue is with your excel file…
column B and column D is having negative numbers with the whole column formatted as date. which is overflow
change your column type to General.