merge_sales_stock_data: merge sales data and stock data from BI database pro

In zyf19940501/ghzy: Ghzy R

Description

full join sales data and stock data pro

Usage

merge_sales_stock_data(
  dates,
  con,
  brand_name,
  channel_type = NULL,
  area_name = NULL,
  boss_name = NULL,
  category_name = NULL,
  shop_no = NULL
)

Arguments

dates	the start date of you select
con	BI con connector
brand_name	the name of brand
channel_type	direct store and franchise store ,the channel of store sales
area_name	area name
boss_name	the franchise customer
category_name	the category name of goods
shop_no	the shop of Number

Value

a dataframe

Examples

mydt <- merge_sales_stock_data(dates = c('2020-01-01','2020-10-11'),con,brand_name = "mujosh")

zyf19940501/ghzy documentation built on Dec. 23, 2021, 10:13 p.m.