topic 0 lines fetched in QlikView

0 lines fetched

Mon, 19 Mar 2012 10:51:46 GMT

Hi All,

when reloading the below script last three lines, meant to create seperate tables for different AccTypes, get 0 lines. Why?

DBS:
SELECT DB_Name FROM Configuration
AccountType:
LET NumberOfDBS = NoOfRows('DBS');
FOR i=0 TO $(NumberOfDBS)-1
LET DB_Name = Peek('DB_Name', $(i), 'DBS');
SELECT
'$(DB_Name)' AS DB_Name, 
CASE WHEN Com_Value = 1 THEN 'ER' WHEN Com_Value = 2 THEN 'KP' WHEN Com_Value = 3 THEN 'KH' END AS AccType
FROM CDN_$(DB_Name).CDN.Company;
NEXT
DBS_ER: NoConcatenate LOAD DB_Name, AccType Resident AccountType Where AccType = 1;
DBS_KP: NoConcatenate LOAD DB_Name, AccType Resident AccountType Where AccType = 2;
DBS_KH: NoConcatenate LOAD DB_Name, AccType Resident AccountType Where AccType = 3;

Regards,

Przemek

0 lines fetched

CELAMBARASAN — Mon, 19 Mar 2012 10:55:33 GMT

Hi,

Here Your account type would be

'ER' or 'KP' or 'KH'

DBS_ER: NoConcatenate LOAD DB_Name, AccType Resident AccountType Where AccType =

'ER';

DBS_KP: NoConcatenate LOAD DB_Name, AccType Resident AccountType Where AccType = 'KP'; DBS_KH: NoConcatenate LOAD DB_Name, AccType Resident AccountType Where AccType = 'KH';

Celambarasan

0 lines fetched

Mon, 19 Mar 2012 11:07:48 GMT

Of course, thank you 🙂