Regarding storing generic table into a qvd

[#1]

Hello Friends,

I appreciate your time!

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

Regards,

Kiru

[Anonymous]

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

[#3]

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 !

[rwunderlich · Accepted solution]

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

[alematex]

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

[#6]

Thanks Rob,

It worked ; I  sincerely appreciate your time;

Kiru

[#7]

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

Kiru