Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
A question of beginner : how can i make an outer join for these 2 tables ?
I tried to use the syntax
join (tab1) LOAD * FROM filename.csv
For each key (@CLE_Site), and each month, i want to have one table with all values.
I also have a problem with the date format of both tables.
Here is an exemple of dataset and qw.
Thank you for your help.
Marie-Claire
Hello Marie,
Actually looking at it once more, let's expand your keying system to an even finer granularity:
FROM: Site + Year
TO: Site + Year + Month
Bilan:
LOAD
AutoNumberHash128 (d_site,d_time_year & num (d_time_month,'00') ) AS %KEY, //key is compound using @CLE_Site + Année + Mois
d_site as @CLE_Site,
d_time_year as Année,
num (d_time_month,'00') as Mois,
m_visits,
m_page_views,
m_time_spent,
m_time_spent_per_pages,
m_entry_rate,
m_entering_visits,
m_time_spent_per_visits,
%Key_DataFeed_1F0D62CF450928BF // Key to parent table: DataFeed
FROM
Visiteurs:
LOAD
AutoNumberHash128(Sites,Left(Subfield(FileBaseName(),'_',3),6)) AS %KEY, //key is compound using @CLE_Site + Année + Mois_Visiteurs
//Sites as @CLE_Site, //** take from table Bilan
//Left(Subfield(FileBaseName(),'_',3),4) as Année, //** take from table Bilan
//Mid(Subfield(FileBaseName(),'_',-1),5,2) as Mois_Visiteurs, //** take from table Bilan
Visiteurs_Uniques_c,
Visiteurs_Uniques_tous
FROM
(
Thank you very much Evan.
Thank you for your help.
Thank you Arjun.
Sure, I will read it !
That is very helpfull : everything on a single sheet !
Thank you very much Enrique.