Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
[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' );
[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' );