Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a qvw app and would like to add/import the sheets that another developer already created. My undersatnding is after the import of the sheet and adding the sql code to the load script it schould all work...column names are all different so...
In the file menu there is an import layout and and Import sheet but both don't work for what I'd like to do...
Any hints much appappreciated...
Thx
L
Hi Ludwig,
I am not quite sure I follow what you are trying to do here, or how far you have got with it so far.
Generally the easiest way to move objects between documents is to open both of them at once do a Select All (Ctrl+A) on the source sheet and copy (Ctrl+C) move to the target sheet and paste them (Ctrl+V).
If the field names are different between the documents you will need to re-point all of these in the objects.
A trick that often works with doing this is to rename all the fields in the target documents load script to match what the field names are in the source document (OldFieldName as NewFieldName). The objects should all then work after a reload. If you then remove the 'as' of each field one at a time and perform a limited load QlikView should update all objects to use the new field name rather than the old.
Hope that helps - please post back more details if I am missing what it is you are trying to do.
Regards,
Steve
Hi Steve,
I think you hit the nail on top...I'll apply the technique you recommended and let you know.
Thx again
Ludwig
Hi Ludwig123, please have in mind that if You are using hidden object, then that object will not copy.
CTRL+A will select all not hidden objects.
As for the metodology i use the same as mentioned 😉 CTRL + A and CTRL + C then CTRL + V.
Best of luck 🙂
Steve,
That does not seem to work. I have two qvw documents and want to have one sheet which is currently in document A.qvw copied to B.qvw...
tried also the file menu....I don't want to repeat all my format work just would like to copy them where I need it...
Any hints?
Thx
Ludwig