Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have a requirement to sum up total sale amount for each region from two different text files. In one file i have geography information and in another file have sales information at sub-region wise. Have to join with first file to get region level total sales information.
example: select total_sales, region from sales, geography where sales.sub_region=geography.sub_region group by geography.region.
Please provide your ideas.
hi
try according to this example
firstly join two table in one table.
NewTable:
table1
join
table2
**************************
then
output:
load
field1,
sum(field2)
resident NewTable
group by field1;