Sheet
cell(range,each_row=False)方法描述 合并单元格 参数说明 range需要合并的范围，必须为 A1:B2的格式 each_row是否行内合并 调用样例-rpa.app.wps.excel.Sheet.merge_cell-#注意事项：使用前需确认已安装WPS相关软件#此方法通过each_row...
Sheet
read read(range,only_visible=False,skip=0,max=1000,read_value_as_str=True)方法描述 从Excel读取值 参数说明 range<str>'A'为列 '1'为行 'A1'为单元格 'A1:B2'为范围 read_value_as_str读取内容的方式，True表示读出的内容为字符串，...
字符串类型相关函数
示例 def echo_each(k,v,u){ s=concat(k,'=',v,' u=',get(u,1))say(s)} if$arg_from { t=split_as_key($arg_from,',')foreach(t,echo_each,['hi,ascript'])} 请求：?from=xx1,xx2,xx3 响应：xx2=xx2 u=hi,ascript xx1=xx1 u=hi,ascript xx3...
JSON函数和操作符
json_each_text(json)→setof record(key text,value text)jsonb_each_text(jsonb)→setof record(key text,value text)select*from json_each_text('{"a":"foo","b":"bar"}')→key|value-+-a|foo b|bar 在指定路径下提取JSON子对象。...
DataWorks On CDP/CDH使用说明
二、数据建模与开发 模块 说明 相关文档 数据建模 数据建模是全链路数据治理的第一步，沉淀阿里巴巴数据中台建模方法论，从数仓规划、数据标准、维度建模、数据指标四个方面，以业务视角对业务的数据进行诠释，让企业内部实现“数同文”的...
配置for-each节点
DataWorks为您提供遍历节点（for-each节点），您可以通过for-each节点来循环遍历赋值节点传递的结果集。同时您也可以重新编排for-each节点内部的业务流程。本文以一个具体示例，通过for-each节点2次循环遍历赋值节点输出结果，并在每次循环...
for-each节点逻辑原理介绍
DataWorks为您提供遍历节点（for-each节点），您可以通过for-each节点来循环遍历赋值节点传递的结果集。同时您也可以重新编排for-each节点内部的业务流程。本文为您介绍for-each节点的组成与应用逻辑。使用说明 您可通过以下内容了解遍历...
alicloud_cen_private_zones
ids-A list of CEN private zone IDs.Each element format as<cen_id>:<access_region_id>.NOTE:Before 1.162.0,each element same as access_region_id.zones-A list of CEN private zones.Each element contains the following ...
通过DataWorks操作Hologres的多个分区子表
当您需要对Hologres中分区父表的多个分区子表进行操作（例如执行INSERT、DELETE或UPDATE）时，可以通过DataWorks的for-each节点的循环遍历功能实现，简化复杂的循环处理逻辑，数据更新成功后即可在父表中查看所有分区数据。背景信息 ...
ValidateTemplate-验证将要创建资源栈的模板
app.app_group[*].server：app 模块未使用 count 和 for_each，app_group 模块使用了 count 或 for_each（app_group 模块是 app 模块的子模块），server 资源未使用 count 和 for_each，对应的 ResourcePath 为 app.app_group.server。...
前言
aos_list_for_each_entry aos_list_for_each_entry_reverse aos_list_for_each_entry_safe aos_list_for_each_entry_safe_reverse 对于 1.0.0 系列SDK，除以下结构体和接口不兼容外，其余均兼容。oss_request_options_t oss_get_object_to_...
高级应用：实现复杂作业逻辑
for-each节点 DataWorks的for-each节点主要用于有循环遍历的场景，且需要与 赋值节点 联合使用，将赋值节点作为for-each节点的上游节点，将赋值节点的输出结果赋值给for-each节点后，一次次循环来遍历赋值节点的输出结果。for-each节点的...
alicloud_oss_buckets
names-A list of bucket names.buckets-A list of buckets.Each element contains the following attributes:name-Bucket name.acl-Bucket access control list.Possible values:private,public-read and public-read-write.extranet_...
alicloud_nas_smb_acl_attachment
1-5-22 and S-1-5-22-23.home_dir_path-(Optional)The home directory of each user.Each user-specific home directory must meet the following requirements:Each segment starts with a forward slash(/)or a backslash().Each segment...
alicloud_nas_access_rules
rule_id(Each element formats as<access_group_name>:<access_rule_id>before 1.53.0).rules-A list of AccessRules.Each element contains the following attributes:source_cidr_ip-SourceCidrIp of the AccessRule.priority-Priority ...
alicloud_slb_acls
ids-A list of SLB acls IDs.names-A list of SLB acls names.acls-A list of SLB acls.Each element contains the following attributes:id-Acl ID.name-Acl name.entry_list-A list of entry(IP addresses or CIDR blocks).Each entry ...
alicloud_market_product
sku_code-The sku code of this product sku.sku_name-The sku name of this product sku.package_versions-The list of package version details of this product sku,Each element contains the following attributes:package_name-The ...
三角形计数
Compute the number of triangles passing through each vertex.*The algorithm can be computed in three supersteps:*I.Each vertex sends a message with its ID to all its outgoing*neighbors.*II.The incoming neighbors and ...
alicloud_cr_ee_namespaces
ids-A list of matched Container Registry Enterprise Edition namespaces.Each item formats as<instance_id>:<namespace_name>.Before 1.161.0,its element is a namespace uuid.names-A list of namespace names.namespaces-A list of ...
字典类型相关
keys,'zeus','4747d33b-12b0-45e6-ac10-a8e191d6*')def echo_each(k,v,u){ s=concat('keys[',k,']=',v)say(s)} foreach(inner_keys,echo_each,[])示例2 d_inner=[]set(d_inner,'name','inner dsl')d_outer=[]set(d_outer,'dictA',d_inner)v...
字典类型相关
keys,'zeus','4747d33b-12b0-45e6-ac10-a8e191d6*')def echo_each(k,v,u){ s=concat('keys[',k,']=',v)say(s)} foreach(inner_keys,echo_each,[])示例2 d_inner=[]set(d_inner,'name','inner dsl')d_outer=[]set(d_outer,'dictA',d_inner)v...
字典类型相关
keys,'zeus','4747d33b-12b0-45e6-ac10-a8e191d6*')def echo_each(k,v,u){ s=concat('keys[',k,']=',v)say(s)} foreach(inner_keys,echo_each,[])示例2 d_inner=[]set(d_inner,'name','inner dsl')d_outer=[]set(d_outer,'dictA',d_inner)v...
alicloud_nlb_server_group_server_attachments
ids-(Optional,ForceNew)The IDs of the servers.You can specify at most 40 server IDs in each call.server_ips-(Optional,ForceNew)The IP addresses of the servers.You can specify at most 40 server IP addresses in each call.ids...
字典类型相关函数
00b7-4551-a6b8-021bb34d1674')set(inner_keys,'zeus','4747d33b-12b0-45e6-ac10-a8e191d6adaa')def echo_each(k,v,u){ s=concat('keys[',k,']=',v)say(s)} foreach(inner_keys,echo_each,[])输出：keys[1]=e66fd4aa-f281-472f-b919-fc7e...
数据可视化
在图层区域，选中刚添加的标签，在大屏中将该标签移动至 AVG score of each course 图表下方，并在右侧的文本内容文本框中输入 AVG score of each course。单击 图标（预览）。效果如下图所示。开启分享。单击 图标。单击 开启分享。单击 ...
alicloud_oos_templates
ids-(Optional)A list of OOS Template ids.Each element in the list is same as template_name.name_regex-(Optional)A regex string to filter the results by the template_name.category-(Optional)The category of template.created_...
ALIYUN:PVTZ:Rule
{"Description":"The information about each virtual private cloud(VPC)that is associated with the forwarding rule.","Value":{"Fn:GetAtt":["ExtensionResource","Vpcs"]} },"Type":{"Description":"The type of the forwarding rule...
alicloud_nas_file_systems
key_id-(Optional,Available in v1.140.0+)The id of the KMS key.zone_id-(Optional,Available in v1.140.0+)The id of the zone.Each region consists of multiple isolated locations known as zones.Each zone has an independent ...
alicloud_waf_domains
ids-(Optional,ForceNew)A list of WAF domain names.Each item is domain name.name_regex-(Optional)A regex string to filter results by domain name.instance_id-(Required)The Id of waf instance to which waf domain belongs....
alicloud_hbase_instance_types
A list of instance types type IDs.types-(Deprecated)A list of instance types.Each element contains the following attributes:value-Name of the instance type.cpu_size-Cpu size of the instance type.mem_size-Mem size of the ...
CREATE TRIGGER
语法 CREATE[OR REPLACE]TRIGGER name { BEFORE|AFTER|INSTEAD OF } { INSERT|UPDATE|DELETE }[OR { INSERT|UPDATE|DELETE }][,.]ON table[REFERENCING { OLD AS old|NEW AS new }.][FOR EACH ROW][WHEN condition][DECLARE[PRAGMA ...
列举文件
objects=bucket.list_objects objects.each {|o|puts o.key } 列举指定前缀的文件 以下代码用于通过prefix参数列举Bucket中包含指定前缀的文件。require 'aliyun/oss' client=Aliyun:OSS:Client.new(#填写Bucket所在地域对应的Endpoint。以...
创建触发器
语法 定义新触发器 CREATE TRIGGER 概要 CREATE[OR REPLACE]TRIGGER name { BEFORE|AFTER|INSTEAD OF } { INSERT|UPDATE|DELETE }[OR { INSERT|UPDATE|DELETE }][,.]ON table[REFERENCING { OLD AS old|NEW AS new }.][FOR EACH ROW][WHEN ...
ALIYUN:SAG:App
5,10,and 15."},"DataPlan":{"Type":"Number","Description":"The quota of the traffic plan that the system allows each client account to use for free each month.Unit:GB.Set the value to 5.Note The system allows each client ...
alicloud_cassandra_backup_plans
ids-A list of Backup Plan IDs.plans-A list of Cassandra Backup Plans.Each element contains the following attributes:active-Specifies whether to activate the backup plan.backup_period-The backup cycle.Valid values:Monday,...
Pig作业配置
Use the GROUP command to group records by n-gram only.-Each group now corresponds to a distinct n-gram and has the count for each hour.uniq_frequency1=GROUP hour_frequency2 BY group:ngram;For each group,identify the hour ...
Pig开发手册
Use the GROUP command to group records by n-gram only.-Each group now corresponds to a distinct n-gram and has the count for each hour.uniq_frequency1=GROUP hour_frequency2 BY group:ngram;For each group,identify the hour ...
alicloud_cr_repos
ids-A list of matched Container Registry Repositories.Its element is set to names.names-A list of repository names.repos-A list of matched Container Registry Namespaces.Each element contains the following attributes:...
alicloud_eci_container_groups
A list of Eci Container Groups.Each element contains the following attributes:container_group_id-The id if ContainerGroup.container_group_name-The name of ContainerGroup.containers-A list of containers.Each element ...
alicloud_cen_route_entries
entries-A list of CEN Route Entries.Each element contains the following attributes:route_table_id-ID of the route table.cidr_block-The destination CIDR block of the route entry.next_hop_id-ID of the next hop.next_hop_type-...
- 产品推荐
- 这些文档可能帮助您