Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
Specialist II
Specialist II

Hi,

call a store procedure...

Regards

André Gomes

Highlighted
Contributor III
Contributor III

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

Highlighted
Specialist II
Specialist II

Hi,

see this thread

Call a function in SQL LOAD

HTH

André Gomes

Highlighted
Contributor III
Contributor III

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