加载脚本
weekday 可用在加载脚本中以返回字符串以及表示星期几的数字,即使已经在脚本中设置了 FirstWeekDay 和 ReferenceDay。下面的加载脚本包括特定的 FirstWeekDay 和 ReferenceDay 值,然后使用 weekday 通过 transaction_date 列中的数据返回表示星期几的字符串和数字。
在示出的结果中,Day 列包含返回的字符串,而 Numeric value of Day 和 Numeric value of week starting from Sunday 包含返回的数值。在加载脚本中,weekday 乘以 1,这是确保返回的数据类型为数值的简便方式。
在数据加载编辑器中,创建新的部分,然后添加示例脚本并运行它。然后,至少要将结果列中列出的字段添加到应用程序中的表格才能查看结果。
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=0;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
Transactions:
Load
*,
WeekDay(transaction_date) as [Day],
1*WeekDay(transaction_date) as [Numeric value of Day]
1*WeekDay(transaction_date, 6) as [Numeric value of a week starting from Sunday],
;
Load * Inline [
transaction_id, transaction_date, transaction_amount, transaction_quantity, discount, customer_id, size, color_code
3750, 20180830, 12423.56, 23, 0,2038593, L, Red
3751, 20180907, 5356.31, 6, 0.1, 203521, m, orange
3752, 20180916, 15.75, 1, 0.22, 5646471, S, blue
3753, 20180922, 1251, 7, 0, 3036491, l, Black
3754, 20180922, 21484.21, 1356, 75, 049681, xs, Red
3756, 20180922, -59.18, 2, 0.333333333333333, 2038593, M, Blue
3757, 20180923, 3177.4, 21, .14, 203521, XL, Black
];
结果
Qlik Sense 表格示出在加载脚本中使用的 weekday 函数的结果。
transaction_id |
transaction_date |
Day |
Numeric value of Day |
Numeric value for a week starting from Sunday |
3750 |
20180830 |
Thu |
3 |
4 |
3751 |
20180907 |
Thu |
3 |
4 |
3752 |
20180916 |
Sat |
5 |
6 |
3753 |
20180922 |
Fri |
4 |
5 |
3754 |
20180922 |
Fri |
4 |
5 |
3756 |
20180922 |
Fri |
4 |
5 |
3757 |
20180923 |
Sat |
5 |
6 |