topic Re: bundle load and drop table issue in QlikView

bundle load and drop table issue

agigliotti — Fri, 22 Jul 2016 07:12:58 GMT

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

Re: bundle load and drop table issue

awhitfield — Fri, 22 Jul 2016 10:39:45 GMT

Hi Andrea,

please post either the full script OR a sample qvw

Andy

Re: bundle load and drop table issue

Anil_Babu_Samineni — Fri, 22 Jul 2016 11:31:52 GMT

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

Re: bundle load and drop table issue

agigliotti — Fri, 22 Jul 2016 12:01:08 GMT

I attached a sample qvw

Re: bundle load and drop table issue

awhitfield — Fri, 22 Jul 2016 13:49:57 GMT

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

Re: bundle load and drop table issue

agigliotti — Fri, 22 Jul 2016 15:21:56 GMT

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.

Re: bundle load and drop table issue

Anil_Babu_Samineni — Fri, 22 Jul 2016 20:11:14 GMT

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

Re: bundle load and drop table issue

agigliotti — Mon, 25 Jul 2016 09:30:31 GMT

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

Re: bundle load and drop table issue

tunoi — Fri, 05 Aug 2016 15:04:40 GMT

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?

Re: bundle load and drop table issue

evan_kurowski — Wed, 21 Sep 2016 17:18:46 GMT

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

Re: bundle load and drop table issue

Mon, 02 Jan 2017 14:00:55 GMT

To add, my tests confirm the same thing.

Another workaround is to do a resident after the bundle info load. This also preserves the images but at least now in the load order you want

Temp:

BUNDLE INFO

LOAD

ImageName,

ImageLocation

FROM ...

Final:

LOAD *

RESIDENT Temp;

DROP TABLE Temp;

This is a bug and will log it if this has not been done already

Re: bundle load and drop table issue

Mon, 02 Jan 2017 14:09:55 GMT

Don't drop temp

Temp:

BUNDLE INFO

LOAD

ImageName,

ImageLocation

FROM ...

Final:

LOAD *

RESIDENT Temp;