cancel
Showing results for 
Search instead for 
Did you mean: 

csv file db table

SOLVED
Highlighted
Occasional Contributor

csv file db table

Hello everybody,
do you know if it is possible through complete tests, to enter the csv / exel file, inserted as a dbtable variable, and make it perform a sorting of a column and then compare it with the sorting generated in the automatic test?

thanks to those who answer

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Re: csv file db table

Thank you Marsha and Robert!

 

Hi @asavoia , did you try implementing this suggestion?


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

3 REPLIES 3
Highlighted
Community Hero

Re: csv file db table

It wasn't quite clear - is your test generating another csv file?  Why not sort the original csv the way you want it in the first place and then compare the new csv to the original csv?  Creating the dbtable seems like an unnecessary step.

Highlighted
Community Hero

Re: csv file db table

I agree.  You have control over the baseline file, I'm assuming.  So, rather than taking it in UNsorted, simply sort it and then do the compare.

Methodology -> I'd probably use a DDT driver of sorts to load the sorted file in and then, row by row, compare it to the on screen table object.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
Community Manager

Re: csv file db table

Thank you Marsha and Robert!

 

Hi @asavoia , did you try implementing this suggestion?


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

New Here?
Join us and watch the welcome video:
Top Kudoed Authors