Qlikview函数的用法
0
Qlikview的dual()函数可以把一个字段的值转换成数值,通过内嵌表我能理解。但是我现在要把事实表里面的一个字段的所有值转换成数值?怎么处理。看了手册上面是这样。但是我发现这样处理后下面表的数据还是文本?怎么样把afile.csv表里面的DayOfWeek 字段转换成数值?
load dual ( string,numrep ) as DayOfWeek inline
[ string,numrep
Monday,0
Tuesday,1
Wednesday,2
Thursday,3
Friday,4
Saturday,5
Sunday,6 ];
load Date, weekday(Date) as DayOfWeek from afile.csv
load dual ( string,numrep ) as DayOfWeek inline
[ string,numrep
Monday,0
Tuesday,1
Wednesday,2
Thursday,3
Friday,4
Saturday,5
Sunday,6 ];
load Date, weekday(Date) as DayOfWeek from afile.csv
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
qjxiaopang - 懒惰是成功的最大绊脚石 2015-11-19 回答
赞同来自: 梁勇
load Date, weekday(Date) as DayOfWeek
FROM afile.xlsx
(ooxml, embedded labels, table is Sheet1)
;
load dual ( string,numrep ) as DayOfWeek inline
[ string,numrep
1,0
2,1
3,2
4,3
5,4
6,5
7,6 ]
;
同时,你只是想把数值对应到周的数值,直接改DayNames显示就可以了
曹浩 - QlikView顾问、QV讲师 2015-11-19 回答
赞同来自: