我正在使用基于分隔符的模板来生成CSV文件
除参数外,所有输出均正常
即使没有在ETEXT中显式添加它们也会显示
如何禁用这些参数
以下是输出
**P_DATE_FROM,P_DATE,P_BU,ID,LOCALE,NAME,JOB_CODE,JOB_FAMILY,JOB_ROLE1,ROLE_IS_REQUIRED12022-01-01T04:00:00.000+04:00,2024 -01-01T04:00:00.000+04:00,,**1,en_US,“Vice President- Investment Management”,3000000003295735,TESLA,“Vice President - Investment Management”,TRUE
这是示例XML
<DATA_DS><P_DATE_FROM>2023-01-01T04:00:00.000+04:00</P_DATE_FROM><P_DATE>2023-03-22T04:00:00.000+04:00</P_DATE><P_BU/><G_1>1en_USVice President - Investment Management<JOB_CODE>300000003295735</JOB_CODE><JOB_FAMILY>TESLA Vice</JOB_FAMILY><JOB_ROLE1>President - Investment Management</JOB_ROLE1><ROLE_IS_REQUIRED1>TRUE</ROLE_IS_REQUIRED1></G_1></DATA_DS>
以下是EDI模板说明
Format Setup:
Hint: Define formatting options…
<TEMPLATE TYPE> DELIMITER_BASED
<OUTPUT CHARACTER SET> iso-8859-1
<NEW RECORD CHARACTER> Carriage Return
Format Data Records :
Hint: Define Data Layout
<LEVEL> DATA_DS
<LEVEL> G_1
<MAXIMUM LENGTH> <FORMAT> <DATA> <COMMENTS>
<NEW RECORD>
15 Alpha ID REFERENCE NUMBER
1 Alpha ‘;’
240 Alpha NAME NAME
1 Alpha ‘;’
240 Alpha DOMAIN DOMAIN
1 Alpha ‘;’
240 Number JOB_ROLE JOB_ROLE
1 Alpha ‘;’
240 Alpha DESCRIPTION DESCRIPTION
1 Alpha ‘;’
240 Alpha JOB_CODE JOB_CODE
1 Alpha ‘;’
35 Alpha MIN_SALARY MIN_SALARY
1 Alpha ‘;’
35 Alpha MAX_SALARY MAX_SALARY
1 Alpha ‘;’
23 Alpha SALARY_CURRENCY SALARY_CURRENCY
1 Alpha ‘;’
35 Alpha JOB_FAMILY JOB_FAMILY
1 Alpha ‘;’
11 Alpha START_DATE START_DATE
1 Alpha ‘;’
11 Alpha END_DATE END_DATE
1 Alpha ‘;’
240 Alpha STATUS STATUS
1 Alpha ‘;’
240 Alpha IS_CRITICAL IS_CRITICAL
1 Alpha ‘;’
240 Alpha KEY_RESPONSIBILITIES KEY_RESPONSIBILITIES
1 Alpha ‘;’
240 Alpha LOCALE LOCALE
1 Alpha ‘;’
240 Alpha NEXT_CARR_STEP1 NEXT_CARR_STEP1
1 Alpha ‘;’
240 Alpha NEXT_CARR_STEP2 NEXT_CARR_STEP2
1 Alpha ‘;’
240 Alpha NEXT_CARR_STEP3 NEXT_CARR_STEP3
1 Alpha ‘;’
240 Alpha NEXT_CARR_STEP4 NEXT_CARR_STEP4
1 Alpha ‘;’
240 Alpha NEXT_CARR_STEP5 NEXT_CARR_STEP5
1 Alpha ‘;’
240 Alpha JOB_ROLE1 JOB_ROLE1
1 Alpha ‘;’
240 Alpha ROLE_IS_REQUIRED1 ROLE_IS_REQUIRED1
<END LEVEL> G_1
<END LEVEL> DATA_DS
感谢你的时间和努力来帮助
关于AR
1条答案
按热度按时间bogh5gae1#
禁用BI Publisher数据模型属性中的“包括参数标记”,如下面的快照所示,这将解决此问题