topic joining two table and make it as single QVD in QlikView

joining two table and make it as single QVD

deep — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

can you help me...
I have joined three tables and I want to create a single QVD for that three tables in QlikView

(how to create single QVD after joining three tables)

Thanks,

Deep

Re: joining two table and make it as single QVD

veidlburkhard — Thu, 06 Feb 2020 11:29:29 GMT

Hi Deep,

If you have joined the three tables, you can store the resulting table as QVD with this command:

Store ResultingTable into NewTablename.qvd (qvd);

That's all.

Hope this helps

Burkhard

Re: joining two table and make it as single QVD

johnpaul — Thu, 06 Feb 2020 11:35:29 GMT

When you say 'join' do you mean that you have linked them with a common field?

Or do you use the concatenate / left join option?

You need to have a single table which you can then store into a QVD or CSV

Re: joining two table and make it as single QVD

Brett_Bleess — Wed, 04 Mar 2020 21:44:28 GMT

Just adding Help link in case someone wants further details on the Store function:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Store.htm

If the other post did get you what you needed, do not forget to return to the thread to close it out by on that post clicking the Accept as Solution button to mark that it was what you needed. If you still have further questions, leave an update, otherwise please do try to close the thread out.

Regards,
Brett