USE OF -F OR -FILE PARAMETER SHOULD NOT BE NEEDED IF USING THE THIRD PARAMETER IN THE GET() FUNCTION AS SEEN IN ITX 9.0.0.2

See this idea on ideas.ibm.com

On ITX 9.0.0.3, the document says,

The -FILE command is optional on input cards and GET rules. (For example, the workbook name is not required if a map uses the File adapter to read an Excel workbook and passes the data in memory to the Excel adapter.)

GET rule: =PARSE(GET("EXCEL", "-W Sheet1 -T", Input))

This rule threw an error as below,
Error code: -8 , Error message: Null argument - -FILE or -F must be specified.

Only when i specify -F <filename> this rule works fine.

=PARSE(GET("EXCEL", "-F filename.xlsx -W Sheet1 -T", Input))

A case was raised and it was agreed that it is a defect.

What is your industry?	Other
How will this idea be used? The -FILE command is optional on input cards and GET rules. (For example, the workbook name is not required if a map uses the File adapter to read an Excel workbook and passes the data in memory to the Excel adapter). Fixing this would enable the rule to work fine on ITX 9003.

Post comment

Guest

Reply
| Dec 3, 2019

Fixed in 9.0.0.4

0 reply Hide replies

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use

USE OF -F OR -FILE PARAMETER SHOULD NOT BE NEEDED IF USING THE THIRD PARAMETER IN THE GET() FUNCTION AS SEEN IN ITX 9.0.0.2

Please enter your email address

RELATED IDEAS

USE OF -F OR -FILE PARAMETER SHOULD NOT BE NEEDED IF USING THE THIRD PARAMETER IN THE GET() FUNCTION AS SEEN IN ITX 9.0.0.2