I need to load a Excel spreadsheet that is pivoted and I can't find a wizard that would make that easy.
should I use QV desktop to create the script then paste it in Qlik Sense?
QlikSense does have a transformation wizard but its not as robust as QlikView yet. You always use the transformation wizard in QV and paste the code in QlikSense. That will cause no harm at all.
Use crosstable statement in your script.
See that link
Thanks guys for your quick follow-up. I ended up using the wizard in QV desktop to generate the script (including the crosstable statement) and pasting it in QS worked fine. Let's hope they improve the wizard in QS soon
Retrieving data ...