topic Re: Regarding storing generic table into a qvd in QlikView

Regarding storing generic table into a qvd

Mon, 18 Aug 2014 20:58:37 GMT

Hello Friends,

I appreciate your time!

Kindly let me know is it possible to store a generic table into a qvd??

Regards,

Kiru

Re: Regarding storing generic table into a qvd

Anonymous — Mon, 18 Aug 2014 21:02:31 GMT

isn't storing to a qvd using store statement working for you?

Re: Regarding storing generic table into a qvd

Mon, 18 Aug 2014 21:09:42 GMT

Thanks for your reply.

Actually, it is giving table name not found error.

If I see in table viewer,

I am seeing the tablename.attribute name instead because of Generic load.

I have attached the appln, kindly let me know your suggestions.

Thanks,

Kiru !

Re: Regarding storing generic table into a qvd

rwunderlich — Mon, 18 Aug 2014 22:07:37 GMT

If you want to store it as a single QVD, you will need to join the separate tables first.

CombinedGenericTable:

Load distinct ContactId as ContactID Resident Contacts;

FOR i = NoOfTables()-1 to 0 STEP -1

LET vTable=TableName($(i));

IF WildMatch('$(vTable)', 'genericload.*') THEN

LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];

DROP TABLE [$(vTable)];

ENDIF

NEXT i

STORE CombinedGenericTable INTO GenericLoad.qvd;

-Rob

Re: Regarding storing generic table into a qvd

alematex — Mon, 18 Aug 2014 22:08:59 GMT

Kiru

when you are loading a generic table, you al loading as many tables as atributtes you had. So when you are trying to store qlikview doesn´t know which one you are calling, and there is the error msg cause

if tou store like this tablename.attibute you can store them separately

Re: Regarding storing generic table into a qvd

Mon, 18 Aug 2014 22:20:53 GMT

Thanks Rob,

It worked ; I sincerely appreciate your time;

Kiru

Re: Regarding storing generic table into a qvd

Mon, 18 Aug 2014 22:21:50 GMT

Thanks so much for your help guys and I sincerely appreciate your time!

Kiru