topic Load only specified tables in QlikView

Load only specified tables

Tue, 19 Oct 2010 16:35:23 GMT

Hey All,

I am wondering if there is someway to only load specific tables into a QVD. I have a text file that has the Table Name I want to load and a variable Y/N that is yes this should be loaded or no this should not be loaded. I want to be able to call the name of a specific table in my load, but I do not know of a command that simply calls a table and then that table has the values of how it will be loaded. Here is some of my code so far:

TextLoad:
LOAD [Data Load],
[Load (Y/N)]
FROM load.txt (ansi, txt, delimiter is '\t', embedded labels, msq);

Let RowCount = NumMax(NoOfRows('TextLoad'),0)-1;

For i = 0 to '$(RowCount)'
Let TempLoadVal = peek('Load (Y/N)', $(i), 'TextLoad');
Let TempDataField = peek('Data Load', $(i), 'TextLoad');
if TempLoadVal = 'Y' then

\\\\Call the Table Load where the table is = TempDataField (ie ExampleTable = TempDataField)

endif
next

ExampleTable:
Load RecordNum as Index,
[Attribute 1] as Attr1,
[Attribute2] as Attr2
From...

I would want to be able to load or call ExampleTable if the value from the txt file read Y. Is there any way to do this or is there a better way to go about this?

Thanks,

Doug

Load only specified tables

pover — Tue, 19 Oct 2010 18:15:50 GMT

Doug, Here's an example using a variable to load from various MSSQL databases that the user defines in QlikView in a list defined in the variable "bds." The same method should apply for dynamic tables and using the loop and peek() that you are using and you just call the table with a $(TempDataField). The double quotes might be necessary. Regards.

//******************************Business Partners Catalog***************************************FULL/PARTIAL RELOAD
for each bd in $(bds);
OCRD:
ADD LOAD '$(bd)' as Database, '$(bd)'&'_'&CardCode as LineID,
CardCode, CardName, LicTradNum, GroupCode, Address, ZipCode, Phone1, Fax, CntctPrsn, City, Country, Balance, CardType,
DebPayAcct, Territory, State1, State2, ExtraDays, CredLimit, SlpCode;
SQL Select T0.CardCode as CardCode, T0.CardName, T0.GroupCode as GroupCode, T0.LicTradNum, T0.Address, T0.ZipCode, T0.Phone1,
T0.Fax, T0.CntctPrsn, T0.City, T0.Country, T0.Balance, T0.CardType, T0.DebPayAcct, T0.Territory, T0.State1, T0.State2,
T1.ExtraDays, T1.CredLimit, T0.SlpCode
FROM "$(bd)".dbo.OCRD T0 JOIN "$(bd)".dbo.OCTG T1 on T0.GroupNum = T1.GroupNum;
next bd