Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have attached a one application in which i have created one simple summary through set analysis. Whether it is possible to generate similar kind of summary at a script level and afterwords out put will be get saved in a .csv file. I not want to use the macro to save the file in excel.
Please help.
Thanks in advance.
Maybe like
INPUT:
LOAD Policy_no,
Year,
Month,
Channel
FROM
[Issuance_1.xlsx]
(ooxml, embedded labels, table is Issuance);
TMP:
LOAD Channel, Month, Count(DISTINCT Policy_no) as CountMonthly
Resident INPUT
GROUP BY Channel, Month;
LEFT JOIN (TMP)
LOAD Channel, Count(DISTINCT Policy_no) as CountTotal
Resident INPUT
GROUP BY Channel;
Result:
LOAD Channel, Sum( If(Month=5,CountMonthly/CountTotal)) as Month..May, Sum( If(Month=12,CountMonthly/CountTotal)) as Month..Dec
RESIDENT TMP
GROUP BY Channel;
DROP TABLE TMP;
Maybe like
INPUT:
LOAD Policy_no,
Year,
Month,
Channel
FROM
[Issuance_1.xlsx]
(ooxml, embedded labels, table is Issuance);
TMP:
LOAD Channel, Month, Count(DISTINCT Policy_no) as CountMonthly
Resident INPUT
GROUP BY Channel, Month;
LEFT JOIN (TMP)
LOAD Channel, Count(DISTINCT Policy_no) as CountTotal
Resident INPUT
GROUP BY Channel;
Result:
LOAD Channel, Sum( If(Month=5,CountMonthly/CountTotal)) as Month..May, Sum( If(Month=12,CountMonthly/CountTotal)) as Month..Dec
RESIDENT TMP
GROUP BY Channel;
DROP TABLE TMP;
Hi,
Thanks swuehl...great.... It's working fine.
Just want to ask one more thing if i have one another table for premium then how can achieve this thing. I have attached one sample application after including this additional table.
How do you want this premium table being merged with the previous table showing the monthly data?
Hi,
I have attached the application and in the summary table i have included the premium.
Thanks for your help Swuehl.
Maybe like attached