Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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' );