Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
So, I have a very simple script and join, which is even simpler. I have several fields with the same name and 2 that I want to join. However, I get this error every time: error 129.
Any tips on how to make qlik sense work? Did I make a mistake somewhere?
my script is:
keywords_sub:
LOAD
reg_cohort as k_reg_cohort,
partner_name as k_partner_name,
ad_id as k_ad_id,
keyword as k_keyword,
request_url as k_request_url
FROM [qvd name]
(qvd);
main_data:
LOAD
"date",
monthname("date") as reg_cohort,
partner_name,
campaign,
ad_group_id,
ad_id,
ad_group_name,
ad_name,
date_rank,
user_id
FROM [qvd2 name]
(qvd);
//--------------
left join (main_data)
LOAD
k_keyword,
k_request_url,
k_reg_cohort as reg_cohort,
k_partner_name as partner_name,
k_ad_id as ad_id
resident keywords_sub;
drop tables keywords_sub;
thank you!