Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

call a SQL Function

Hi!

I have to call a SQL Function from SQL Server, with a string field as parameter. This function returns a string. Can I call a SQL Function in the Load Script? How?

Thanks!

__________________________

Hola,

Tengo que llamar a una función de SQL Server, pasandole por parametro un campo string y que me devuelva ese mismo campo depurado. ¿Se puede llamar a una función en el Load Script? ¿Como?

Gracias!

4 Replies
agomes1971
Specialist II
Specialist II

Hi,

call a store procedure...

Regards

André Gomes

Anonymous
Not applicable
Author

I have to call a function, this function deletes html labels and returns the string.

agomes1971
Specialist II
Specialist II

Hi,

see this thread

Call a function in SQL LOAD

HTH

André Gomes

Anonymous
Not applicable
Author

Hi,
1. If that function is simple then Call the function as normal sql statement from Qlik View as below.
QVtable:
Load *;
select * from [DB]..StringToList('1:2',':');
2. Else Use stored procedure to call the function and execute the procedure in Qlik View