Count rows in an unique column in QTP's global datatable

Question

Count rows in an unique column in QTP's global datatable

SBsteve (TechnicalUser)

(OP)

14 May 08 09:21

Quick Test Pro (QTP) 9.0
Windows XP sp 2

Question:

When importing an excel file that has several columns each
with different number of rows into QTP's Global datatable,
how can you count the number of rows in a particular column?

Thanks,
SBsteve

DPlank (IS/IT--Management) · Answer 1 · 2008-05-14 11:13:43

Hi SBSteve

QTP works on the prerequisite that each row of the Global datatable is one iteration of the test being executed.

This means that each column will require the same number of rows, or at least handling where individual columns have no data.

AFAIK, the only way you could do this would be with an instance of the FileSystemObject, examining the excel version of the file, but that's not likely to help you in what you are trying to achieve.

Can you explain what you're trying to do and the composition of your data? That will help direct the answer.

Cheers,
Dave

"Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me

For all your testing needs: forum1393: Systems & Software Testing

SBsteve (TechnicalUser) · Answer 2 · 2008-05-14 13:14:55

Thanks for your reply Dave, but I think I may have been on the wrong path.

Please see my new post on Nested Loops.

Thanks,
SBsteve

Come Join Us!

Posting Guidelines

Jobs

Count rows in an unique column in QTP's global datatable