Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As in the title - is there an equivalent of SQL @@ROWCOUNT function in QlikView?
Regards,
Przemek
I'm not expert on Transact-SQL... but is it like an Mapping routine?
Hi.
I guess no.
What is the purpose to have it ?
You may create a field with the function RowNo()... and then calculate the maximum value of it?
I need to apply tens of replace statements to clean text. For that, I've got the below SQL script but would like to transfer it to QV. I've tried with peek loops but with no success. If I'd nest the replace statements, I'd end up with something like a meter long script line.
WHILE @@ROWCOUNT >0
UPDATE T
SET Text = REPLACE( T.Text, V.Variable, V.Replacetext)
FROM #Text AS T CROSS JOIN #vars AS V
WHERE T.Text LIKE '%'+V.Variable +'%'
I'm not expert on Transact-SQL... but is it like an Mapping routine?
Sure it is 🙂 Rob's Cookbook has perfect example for that. Thanks.