LOAD statement

[marco_puccetti]

Hello, i've noticed that when i make a load of some datas, is generated the qvd (with store command) but the table in-memory is not created, is it possible?

Thanks

Marco

[petter]

Not unless the table is dropped or QlikView finds out that what you are loading from the QVD can be auto concatenated. The last option is that you force concatenate the QVD - which you would obviously know about by using CONCATENATE in front of the LOAD statement.

[petter]

By the way ... a mapping load table will vanish by it self at the completion of the load script.

[alexandros17]

No it is not possible, you have to find the table in memory, plase share with us you script

[petter]

There is a statement called DROP that can drop one or more tables explicitly:

DROP TABLE TempTable;

DROP TABLES TempDates1, TempDates2;

[marco_puccetti]

The code is like this:

TAB:

LOAD

     Field 1 as A,

     Field 2 as B,

     ........,

     Field n as Z

FROM URL; (qvx)

Store TAB Into '$(pathToFile)';

And i get the qvd file, but not the table TAB in the Tables Visualizer.

Thanks

Marco

[marco_puccetti]

The exact code is this:

'****************************************************************************

let inst_pro_media = '$(vQvdPath)\INST_Media.qvd';

let size = filesize('$(inst_pro_media)');

if not isnull(size) then

  INST_Media:

  LOAD * FROM '$(inst_pro_media)' (qvd);

end if

if(vGetLatestData=1) then

  let noRows = NoOfRows('InstagramSites'); // get the total number of rows in the table

  for i=0 to $(noRows)-1 // loop through every row

  let site = peek('tSite', $(i), 'InstagramSites'); // get the value for "site" field on each row

  let page = peek('tpage', $(i), 'InstagramSites');  // get the value for facebook page

INST_Media:

LOAD

  id as MediaByTag_id,

  min_tag_id as MediaByTag_min_tag_id,

  max_tag_id as MediaByTag_max_tag_id,

  type as MediaByTag_type,

  tags as MediaByTag_tags,

  location_id as MediaByTag_location_id,

  location_name as MediaByTag_location_name,

  location_latitude as MediaByTag_location_latitude,

  location_longitude as MediaByTag_location_longitude,

  filter as MediaByTag_filter,

  link as MediaByTag_link,

  created_time as MediaByTag_created_time,

  created_time_utc as MediaByTag_created_time_utc,

  timestamp#(created_time_utc, 'DD-MM-YYYY hh:mm:ss') as MediaByTag_created_time_utc_qlik_timestamp,

  date#(left(created_time_utc, 10), 'DD-MM-YYYY') as MediaByTag_created_time_utc_qlik_date,

  comments_count as MediaByTag_comments_count,

  likes_count as MediaByTag_likes_count,

  caption_created_time as MediaByTag_caption_created_time,

  caption_created_time_utc as MediaByTag_caption_created_time_utc,

  timestamp#(caption_created_time_utc, 'DD-MM-YYYY hh:mm:ss') as MediaByTag_caption_created_time_utc_qlik_timestamp,

  date#(left(caption_created_time_utc, 10), 'DD-MM-YYYY') as MediaByTag_caption_created_time_utc_qlik_date,

  caption_text as MediaByTag_caption_text,

  caption_from_username as MediaByTag_caption_from_username,

  caption_from_profile_picture as MediaByTag_caption_from_profile_picture,

  caption_from_id as MediaByTag_caption_from_id,

  caption_from_full_name as MediaByTag_caption_from_full_name,

  caption_id as MediaByTag_caption_id,

  images_low_resolution_url as MediaByTag_images_low_resolution_url,

  images_low_resolution_width as MediaByTag_images_low_resolution_width,

  images_low_resolution_height as MediaByTag_images_low_resolution_height,

  images_thumbnail_url as MediaByTag_images_thumbnail_url,

  images_thumbnail_width as MediaByTag_images_thumbnail_width,

  images_thumbnail_height as MediaByTag_images_thumbnail_height,

  images_standard_resolution_url as MediaByTag_images_standard_resolution_url,

  images_standard_resolution_width as MediaByTag_images_standard_resolution_width,

  images_standard_resolution_height as MediaByTag_images_standard_resolution_height,

  videos_low_bandwidth_url as MediaByTag_videos_low_bandwidth_url,

  videos_low_bandwidth_width as MediaByTag_videos_low_bandwidth_width,

  videos_low_bandwidth_height as MediaByTag_videos_low_bandwidth_height,

  videos_standard_resolution_url as MediaByTag_videos_standard_resolution_url,

  videos_standard_resolution_width as MediaByTag_videos_standard_resolution_width,

  videos_standard_resolution_height as MediaByTag_videos_standard_resolution_height,

  videos_low_resolution_url as MediaByTag_videos_low_resolution_url,

  videos_low_resolution_width as MediaByTag_videos_low_resolution_width,

  videos_low_resolution_height as MediaByTag_videos_low_resolution_height,

  user_has_liked as MediaByTag_user_has_liked,

  user_username as MediaByTag_user_username,

  user_profile_picture as MediaByTag_user_profile_picture,

  user_full_name as MediaByTag_user_full_name,

  user_id as MediaByTag_user_id,

  users_in_photo_count as MediaByTag_users_in_photo_count,

  users_in_photo_user_ids as MediaByTag_users_in_photo_user_ids

FROM

  [$(vQVSourceBaseUrl)/QVSource/InstagramConnector/?table=MediaByTag&appID=$(vQVSourceAppId)&tag=$(site)](qvx);

    //call logQVSourceError(scripterrordetails, 'Instagram\Page\$(site)');

  trace "Tw Follower Url: " & $(vQVSourceBaseUrl)/QVSource/InstagramConnector/?table=MediaByTag&appID=$(vQVSourceAppId)&tag=$(site);

   next

  STORE INST_Media INTO '$(inst_pro_media)';

end if

'****************************************************************************

[alexandros17]

Are you sure that the qvd is filled with values?

I think that you are creating an empty file (.qvd) starting from a table with no rows (this coult be the reason for which the table is not shown)

Let me know

[petter]

The only reason you could have for not getting a table in-memory is that the QVD you are loading from is empty or does not exist and the QVX's that the FOR NEXT loop is retrieving from does not have data or they don't exist. There is a test also against a variable vGetLatestData which it will act upon to either fetch new data or not.

Whether the script reports the errors or not depends on your error reporting setting - which you can change with the variable ErrorMode.

[marco_puccetti]

I have tried to load the qvd and it presents data inside.

What's this ErrorMode variable, and how should be setted?

Marco