Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

julioarriaga
Contributor II

Is it a good practice to create a crosstable in the extractor?

Hi,

I am loading some tables to save them in the raw qvds I will need for my application. I was wondering: can I get away with loading extract qvds as crosstables or should I only extract that information without any transformation whatsoever as a best practice?

Thank you.

Tags (1)
1 Solution

Accepted Solutions

Re: Is it a good practice to create a crosstable in the extractor?

Depending on how your data looks it might make sense to use CrossTable load... Do you have pivoted data?

2 Replies

Re: Is it a good practice to create a crosstable in the extractor?

Depending on how your data looks it might make sense to use CrossTable load... Do you have pivoted data?

julioarriaga
Contributor II

Re: Is it a good practice to create a crosstable in the extractor?

Thank you for your reply, I have data that I need in a pivoted way for an app (it is large), so that was why I was wondering if it was better to:

a) To have the pivoted data in a table/view previous to the extractions of QlikView

b) To crosstable load the information in the QV extraction step

c) Pivot the data in the QV transformation step

Regrds.

Community Browser