Datastage - Unstructured Stage gives invalid character error if the sheet name has a hyphen

Issue

The Excel workbook has multiple sheets. One sheet name that we want to read has the name 'Sales - Data'.

We design a Datastage job using the Unstructured stage to read data only from this sheet.
Sales - Data!A1:D50

The stage gives an invalid character error and does not accept the sheet name.

Solution :

Give the sheet name within single quotes. Datastage - Unstructured stage presumably treats the hyphen as a minus and hence we need to escape this special character using single quotes.

'Sales - Data'!A1:D50

Post a Comment

Previous Post Next Post

Contact Form