Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can i display the number of rows affected by the query in the title of a table?
Thx!@
If you have field that identifies rows uniquely, you can simply use =Count(RecIdentifierField). And if you don't have such a field in db itself, you can create one during load like:
Load
*,
RowNo() as RecIdentifierField
From <>;
Thx, but now i want to concatenate text and the count in the titlefield.
E.g.
Total amount of numbers: 9
The title is an expression so following on from tresescomaybe something like this for the expression :
= 'Total amount of numbers: ' & Count(RecIdentifierField)