我想做以下事情
Loop at itab into wa_itab.
wa_itab2-field1 = wa_itab-field1.
wa_itab2-field2 = wa_itab-field2.
wa_itab2-field3 = wa_itab-field3.
wa_itab2-field4 = wa_itab-field4.
*how to insert in itab2 if fields 1,2 & 3 do not exist or update itab2 if fields 1,2 & 3 exist?
EndLoop.
让我解释
是否可以将INT字段更改为日期字段?
我有下面的脚本-然而,我希望[DelDateKey]显示为日期DD/MM/YYYY。
select[DelDateKey],
sum([Order]), sum([ACS]), sum([Pick]) , sum([DIS])
FROM
[pw].[WA].[Sales]
WHERE [IdKey]= 1
and [DelDateKey] in (select distinct top 7 [DeldateKey] from [pw].[WA].[Sales] order by [DeldateKey] desc )
嗨,我正在尝试绘制华盛顿金县的地图,因为我几乎没有需要放在地图上的数据点。下面是我使用的代码。 long <- c(47.5112,47.7210 ,47.3684,44)
lat <- c(-122.257, -122.319, -122.031,-120)
price <- c(287655,456355,662500,234563)
House <- data.frame(long, lat, price)
states <- map_data("state")
# west_coast <- states %>%
#