bundle load and drop table issue

[agigliotti]

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

[awhitfield]

Hi Andrea,

please post either the full script OR a sample qvw

Andy

[Anil_Babu_Samineni]

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

[agigliotti]

I attached a sample qvw

[awhitfield]

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

[agigliotti]

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.

[Anil_Babu_Samineni]

I don't think so what are you trying to asking you. See, I just load the image. Check that

[agigliotti]

ok now let's create a new table and add a drop table statement as last line of script and see what happens.

[tunoi]

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?

[evan_kurowski]

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
];