Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm facing the problem with bundle load table that is being deleted after any drop table statement.
ex.
TAB_1:
Bundle LOAD * INLINE [
Image Name, Image Location
Up, images/FrecciaSu.png
Down, images/FrecciaGiu.png
];
...
...
...
DROP Table B;
After the drop table also the TAB_1 table named as "$orphan_Image Name" is deleted.
I think this is not the expected behavior.
I tried with both version 11.20 and 12.0
Someone can explain me ?
Many thanks in advance.
Best Regards
Andrea
Hi Andrea,
please post either the full script OR a sample qvw
Andy
Andrea,
Can you post your Excel Or Images. Because, You are taking images from Inline, I don't think so if you have those images on your Path or Not. Else try to put whole path on your inline and then create straight table with the Dim of [Image Name] and Expression is [Image Location] then use the option Image instead of Text.
Might be helpful
I attached a sample qvw
Hi Andrea,
this isn't an issue, the orphan table is created when you perform a Bundle Load and the images are not directly associated with other data files.
Check out QlikView Technical Brief - Loading Images into QlikView.zip
Andy
Yes I know but the orphan table should not be deleted, from data cloud, after any DROP TABLE statement because it causes the images are not longer available within the document.
I don't think so what are you trying to asking you. See, I just load the image. Check that
ok now let's create a new table and add a drop table statement as last line of script and see what happens.
i have the same issue.
Here is my script:
temp_images:
LOAD * INLINE [
ImageName, KPIImage
UpGreen, Pictures\icon_ArrowUp.G.png
DownRed, Pictures\icon_ArrowDown.Red.png
DownGreen, Pictures\icon_ArrowDown.G.png
UpRed, Pictures\icon_ArrowUp.Red.png
];
Image:
bundle info Load
ImageName as [Image Name],
'$(v_environment)\' & KPIImage as Image
resident
temp_images
;
drop table temp_images;
if i comment the last line( drop table...) i can use the images loaded as bundle in interface but if i drop that temp table my images disappears. Any idea why and how to drop the table without losing the images?
Can confirm experiencing the same behavior, and it seems every BUNDLE load that occurs before any given DROP statement is lost, and this can occur multiple times within a single script.
As a workaround, I'm finding moving all the BUNDLE statements till after the very last DROP statement in the script allows the bundled info to be preserved.
(But it seems like this is either a bug, or the importance of sequencing and interactivity with the DROP statement should be added to the instruction manual entries)
//With this ordering of statements, both sets of bundled images from [Images] & [Images2] are lost by script end
[Images]:
BUNDLE LOAD * INLINE [
Image, Source
cust_red, C:\images\My_red.png
];
[T1]:
LOAD * INLINE [
F1
a
];
DROP TABLE [T1];
[Images2]:
BUNDLE
LOAD * INLINE [
Image2, Source2
cust_green, C:\images\My_green.png
];
[T2]:
LOAD * INLINE [
F2
a
];
DROP TABLE [T2];
exit script;
//** Workaround
//When all BUNDLE load statements are moved to after the last DROP statement in the script, all of the bundled images are present upon script completion
[T1]:
LOAD * INLINE [
F1
a
];
DROP TABLE [T1];
[T2]:
LOAD * INLINE [
F2
a
];
DROP TABLE [T2];
[Images]:
BUNDLE LOAD * INLINE [
Image, Source
cust_red, C:\images\My_red.png
];
[Images2]:
BUNDLE
LOAD * INLINE [
Image2, Source2
cust_green, C:\images\My_green.png
];