I have 2 Excel one is real excel and second is failed excel. I want to extract data from excel(Real) on the behalf of real excels time in state and I want it to create another violation excel report if the value of threshold field is grater than the time in state. Real.xlsx (9.6 KB) Failed.xlsx (10.3 KB)
(From r In dtInput
Join d In dt2
On r("Actual State").ToString().ToUpper() Equals d("Actual State").ToString().ToUpper()
Let State = DateTime.ParseExact(d("Time in State").ToString(),{"hh:mm", "hh:mm:ss", "hhmmss", "hhmm", "h:mm", "h:m", "hmm", "HH:mm", "H:mm"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("HH:mm")
Let Threshold = DateTime.ParseExact(d("Threshold Failed").ToString(),{"hh:mm", "hh:mm:ss", "hhmmss", "hhmm", "h:mm", "h:m", "hmm", "HH:mm", "H:mm"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("HH:mm")
Where State > Threshold
Let ra = New Object(){d("Actual State"), d("Time in State"), d("Threshold Failed")}
Select dtResult.Rows.Add(ra)).CopyToDataTable()
Looks like the reference is missing…please check if the reference is present by opening the xaml in notepad…please try renaming project.json also and reopen main and check
Can you attach the complete project here please
@fernando_zuluaga did you happen to send whole project? Or only a xaml
One possible reason could be the version differences and references might have been missed…
I see @Himanshu_Pratap_Rana versions are 22.10.x and i guess you did on community with latest versions 23.x which would have caused this reference issue
Kindly replace the filter code in the assing activity to this new code
(From r In dtInput.AsEnumerable()
Join d In dt2.AsEnumerable()
On r("Actual State").ToString().ToUpper() Equals d("Actual State").ToString().ToUpper()
Let State = DateTime.ParseExact(d("Time in State").ToString(),{"hh:mm", "hh:mm:ss", "hhmmss", "hhmm", "h:mm", "h:m", "hmm", "HH:mm", "H:mm"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("HH:mm")
Let Threshold = DateTime.ParseExact(d("Threshold Failed").ToString(),{"hh:mm", "hh:mm:ss", "hhmmss", "hhmm", "h:mm", "h:m", "hmm", "HH:mm", "H:mm"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("HH:mm")
Where State > Threshold
Let ra = New Object(){d("Actual State"), d("Time in State"), d("Threshold Failed")}
Select dtResult.Rows.Add(ra)).CopyToDataTable()