Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Karineyumi
Contributor II
Contributor II

Script Load with one Key from Tables that were joined

Hi everyone, please help meeee.

 

I have tree tables one called "Saleskit", the other "Monthstable" and the "Database":

Which basically, I have a whole database for budgets segmented by customer/sales rep/year, and i need to show those numbers by year/month/week, with that, I joined the "Saleskit" with "Monthstable" to create lines for me by Month/week for each budget. 

And finally I need to create a key from the joined "Saleskit" + "Monthstable" table into my "Database" :

 

"Lara code"&"Export / Import/ FF"&Year1&Month1&Week1 as SaleskitKey

 

SALESKIT:
LOAD
Country as "Sales Country",
"Sales Manager",
"Sales rep",
"Sales Role",
"Lara BP code" as "Lara code",
"Customer name",
"Export / Import/ FF",
"Vol. Budget (Teus)"/52 as "Vol. Budget (Teus)",
Segmentation,
"Year1"
FROM [lib://QS_Projects_BA_Miami_RO/30_External source files/SALESKITDATABASE.qvd]
(qvd);

 

join
Monthstable:
LOAD
Year1,
Month1,
Week1
FROM [lib://AttachedFiles/Monthstable.xlsx]
(ooxml, embedded labels, table is Monthstable);

 

 
SALESKITMONTH:
Load
"Sales Country",
    "Sales Manager",
    "Sales rep",
    "Sales Role",
    "Master Customer Name",
    "Customer name",
    "Vol. Budget (Teus)",
    "VAS Budget ($)",
    "CH Budget (Teus)",
    Segmentation,
    Category,
    "Master BP code",
    "Country_Code",
"Lara code"&"Export / Import/ FF"&Year1&Month1&Week1 as SaleskitKey
Resident SALESKIT;
 
drop Table SALESKIT;

 

The problem that I`m having is that not all the customers in the Saleskit will be in the Database and vice versa. But I need to have both information, so its showing a lower Budget from Saleskit then it should. 

 

**I cannot do the Month/week inclusion in the excel (which is were my data comes from) because i have around 700.000 lines on Saleskit table and I have a 3 year worth of data to have month/weeks numbers 😕

 

thank youuuuu appreciate your help. 

 

 

Labels (2)
0 Replies