If condition else part alone is working

Buddy i didnt get you , can you come again…
Cheers @priyankavivek

Buddy @priyankavivek i saw you xaml, it didn’t have any errors and logical mismatch as well
but i would like suggest you that make sure if these are the columns to be compared, sometimes we might dissenter the value wrongly with column index…so if you are sure with the column name kindly mention them directly within double quotes like this
row(“columnname”).ToString.Trim.Equals(row1(“Columnname”).ToString.Trim)

Lets try this buddy
Cheers @priyankavivek

1 Like

have any idea on this my first column on output excel is not showing any values ?

i would try this now thankyou

Thats great…
Cheers
@priyankavivek

1 Like

i think this must be the problem
better try with column name buddy
that would work for sure
and i think that column must be hidden,
unhide it and try buddy @priyankavivek
@priyankavivek

This excel might have hidden column. Try reading the complete and check the contents of datatable. And to avoid indexing please use column names instead of column number.

1 Like

datatable i have checked i will try with column name

i have got the result as “yes” the condition which is not satisfying i need to make it no

using (hint :null)condition any idea on this?null i have to fill the empty as “no”

1 Like

Well,

if the aim is just to fill empty as ‘No’

Then ,
Read range of the excel file : →

  1. For each row in data table
  2. Open another while loop
  3. if - row (count).ToString.Trim.Equals(“”) then assign YourDataTable.(rowCount)(ColumnCount)=“No”
  4. Write range in Excel again.

I think this will work .

Regards :slight_smile:

1 Like

Yes buddy ofcourse here is your sample xaml for this @priyankavivek
to mark null with NO @priyankavivek
no.zip (9.5 KB)

Cheers

1 Like

Did that work buddy… @priyankavivek

checking on that buddy

1 Like

any issue still buddy @priyankavivek

1 Like

i used another if condition to check whether it is "no"its working fine buddy,thanks for your reply!!!thank you so much…

1 Like

thank you so much it working fine now! thanks for your help

1 Like

Fantastic
Cheers @priyankavivek

1 Like

Kindly make a solution buddy @priyankavivek

still i have queries can i proceed?

sure buddy @priyankavivek