Loading several fields with a flag field holding photos

[#1]

Hello,

Plz how do i load several fields with a flag field holding photo link. Find attached

I used

Country:

Bundle Info

LOAD Country,

     Code,

     Staffs,

     Position,

     Designation,

     Flag

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

But i only found country on my field after reloading. what do i do?

Rgds

Ema

[#2]

INFO Tables, must contain only two(2) fields ?. Try the following:

CountryImages:

Bundle Info

LOAD Country,

     Flag

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Country:

LOAD Country,

     Code,

     Staffs,

     Position,

     Designation

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[#3]

Hi Emac,

Please follow below steps ....

a. Reload the data

b. I thought in the below screen ur selected country....pls check this once.

c. with out selecting...press okay.

d. Right Click > New Sheet Object > Table Box > (Now select the fields)

Note :- If your not specified any table name, here Excel Sheet name is table name default.

Please check this, I hope it will help ful for you.

Happy weekend.....

Regards,

Sub2u

[#4]

Sub2a,

What he is trying to achieve is to load the flags images and store them internally into the Qview document, so they can be reference back using qmem:// sintax, it's not a normal LOAD as you specify.

So, bundle info is a special load statement that only supports two columns inside the load statement.

[#5]

Hi Mario,

I agree with your discussion, I thought he is getting one filed as pasted in above pic b.

Thanks for your response.

Small Doubt :-

Country:

LOAD Country,

     Code,

     Staffs,

     Position,

     Designation

     //Flag

FROM

Flags.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq); -- I get all fields to display

CountryImages:

Bundle Info

LOAD Country,

//     Code,

//     Staffs,

//     Position,

//     Designation,

     Flag

FROM

Flags.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq); -- i did not get this table in UI for showing

**

CountryImages:

Bundle Info

LOAD

   //    Country,

//     Code,

//     Staffs,

//     Position,

//     Designation,

     Flag

FROM

Flags.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq); -- i take like this after facing problem with the above one

Getting wrong info like it was showing image for all same i.e., first one..

Can you please help me with this...

I have tried already the Before function, without success.

So, if somebody could help I really appreciate.

Thanks in advance,

Sub2u

[#6]

What i want to achieve is to load as many fields as possible including flag field

[#7]

Out of scope

[#8 · Accepted solution]

Dear Sirs,

Enclosed is the file showing my answer .  It loads first the Bundle Info and then the rest of the TAble. qmem://Code is available for showing pictures or flags . 

[#9]

Sub2a,

Enclosed is the file. Bundle Info loads won't show up in the Table Viewer. They are available in the Expression editor under Image tab. or using qmem:// sintax. review the code. One thing important is that the Expression in the Table should be set to Represent Image, otherwise qmem:// will show up instead of the actual image.

[#10]

See attached file. You have to do it in two steps. First create your bundle info load with just two columns a key (ie: Country or Code and second column the flag containing directory location to a flag file. After this load the bundle is created inside the document,

just then, you can load Again the same csv file but not using bundle info , just use regular load, and don't include the flag column this time. see attached file in another reply.