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)
Can you share the expected output?
What do you mean by this? Can you tell us more details
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
convert 4 decimal value in salary colume
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
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
Compare&DeleteRow.xaml (23.6 KB)
in this file
i was doing
- compare row and delete full row
- 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
- 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
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
To round of the value you can try with this expression
Math.Round(CDbl(CurrentRow("Salary").ToString))
Regards
Gokul
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.