Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
homee
Contributor III
Contributor III

Add date to loaded data

Hi, 

i am loading our facebook page likes. Unfortunately these are returned without the current date so my question is how can i add the current date and then store the table?

 

Thats what i currently have: 

LIB CONNECT TO 'Facebook_Fan_Pages - BLABLA';

[pagelikes]:
LOAD
	id as [Page.id], 
	likes as [Page.likes], 
	talking_about_count as [Page.talking_about_count];

SELECT id,
	likes,
	talking_about_count
FROM Page
WITH PROPERTIES (
id='11111111111'
);

Store [pagelikes] into [lib://homee-Daten:DataFiles/pagelikes.qvd](qvd);

DROP TABLES [pagelikes];


Sleep 60 * 1000;//ms
Labels (1)
1 Solution

Accepted Solutions
jochem_zw
Employee
Employee

[pagelikes]:
LOAD
	id as [Page.id], 
	likes as [Page.likes],
Date(Today()) as Date, talking_about_count as [Page.talking_about_count]; SELECT id, likes, talking_about_count FROM Page WITH PROPERTIES ( id='11111111111' );

View solution in original post

1 Reply
jochem_zw
Employee
Employee

[pagelikes]:
LOAD
	id as [Page.id], 
	likes as [Page.likes],
Date(Today()) as Date, talking_about_count as [Page.talking_about_count]; SELECT id, likes, talking_about_count FROM Page WITH PROPERTIES ( id='11111111111' );