Excel file sheet

convert decimal value in excel file
in price columns
and check date Column if date is greater then current date then Delete the full row in excel sheet.
Book.xlsx (9.9 KB)

Hi @purnima_mandan

Can you share the expected output?

What do you mean by this? Can you tell us more details

@purnima_mandan

How about this expression

DateTime.ParseExact(CurrentRow("Date").ToString,"MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).Date>Today

Check out this XAML file for Greater than date

Compare&DeleteRow.xaml (19.0 KB)

Regards
Gokul

sorry this was my mistake in salary colume we have to convert decimal value

Can you share the expected output? @purnima_mandan

convert 4 decimal value in salary colume

Can’t able to understand ? @purnima_mandan

have you checked this XAML file?

i was do this date colume but output was not correct in your xmal file you comment out the filter data table can you able to enable and run it what output you get
because i didnot get right output

please help me for these @Gokul001

Can you tell us what is not correct in the XAML file?

Based on this requirement

The XAML file will work can you check out this. Comment out the Filter Data Tbale and If activity and run the flow.

Instead of telling Not working give some proof whaqt is not working where is not working thinks like that.

Regards
Gokul

Book.xlsx (9.9 KB)

Compare&DeleteRow.xaml (23.6 KB)

this is the xmal file in that file i was doing comapare delete row and also date greater than delete row and also convert decimal to round off

so that my problem was that

in that file can you solve the sequence of these 3 condition so my program was run and get right output

this was my problem @Gokul001

please solve these

Check out this XAML file @purnima_mandan

This is the Output snap

image

Regards
Gokul

Compare&DeleteRow.xaml (23.6 KB)

@Gokul001

in this file
i was doing

  1. compare row and delete full row
  2. date greater than delete row
    3)in salary colume i convert decimal to round of

so this condition was right in the xmal file

but problem was that

process sequence was not right in my file
that’s why i comment out two sequence

  1. date
    2)decimal convert

so my question is that can you able to fix the position of these 3 condition
you can enable the comment out portion and run it so what out put you get
and share me the proper workflow with these 3 condition in excel file

Hi @purnima_mandan

How about this expression?

DateTime.ParseExact(CurrentRow("Date").ToString,"MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).Date>Today Or DtOutput.Rows.Count>=1

Check out this XAML file

Compare&DeleteRow.xaml (19.2 KB)

Output Snap

image

To round of the value you can try with this expression

Math.Round(CDbl(CurrentRow("Salary").ToString))

image

Regards
Gokul

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