If value is not null

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

1 Like

Hey @mitul_choudhary

You mean the excel doesn’t have any rows ?

#nK

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:-
image
Please help with the code

1 Like

Please share excel …

1 Like

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

1 Like

@Nithinkrishna is it done bro…?

1 Like

StringSplitIdDesc.zip (25.2 KB)

Hope this helps

Thanks
#nK

1 Like

@Nithinkrishna
It’s coming again
image

@Nithinkrishna pls help on this >>!!!

1 Like

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

1 Like

@Nithinkrishna
I want like this:_
image

@Nithinkrishna is it done bro…?

1 Like

Sorry My mistake

Please make this change

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

#nK

1 Like

@Nithinkrishna

1 Like

Are you running with any empty values ?

@Nithinkrishna leave that while
running bot this is coming

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

1 Like

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

1 Like

@Nithinkrishna Please help on this bro.!!

1 Like

Hey @mitul_choudhary

This should not be a code issue I guess

Have your tried with different files

@Nithinkrishna yes from other it’s working fine

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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.