Problem to run Scalar Function in QlikView

[lylererger]

Hi friends!

Help me to solve the next problem:

When I'm running SQL query using scalar function - all is working fine

But when I'm trying to extract data using that scalar function - QlikView writes OLEDB read failed

Why ? Help!

Thnx in advance...

[petter · Accepted solution]

You should give your two calculated columns an alias which will help QlikView to accept them. QlikView need unique column names being passed from the SQL SELECT statement.

So modifying your SQL query to something like this should work well (the bolded part has to be added):

SQL

    SELECT DG_CODE,

          dbo... xxxxxxxxxxxxx     AS Calc1,

          dbo... yyyyyyyyyyyyy     AS Calc2

     FROM

          zzzzzzzzzz

;

[lylererger]

Omg... Petter thanks.