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.
