Direct Query along with INFO query

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can we use Direct query along with Info query in direct discovery of QlikView.

I have binary image data which I am fetching using -

INFO IMAGE_SIZE(120, 120) SELECT "binarycolumn", "binarycolumn" FROM "mkhati"."public"."employees";

The image path may change, and we need direct discovery for same.

How to use that.

Please assist.

Thanks & Regards,

Re: Direct Query along with INFO query

Anil_Babu_Samineni — Thu, 13 Oct 2016 14:10:46 GMT

Like this

BINARY Load "binarycolumn", "binarycolumn" FROM "mkhati"."public"."employees";

And then Give Height and Width From Caption Tab