How can we setup the TypeDetectionScheme when using Excel Query Component

Data Productivity Cloud
1

Hi Matillion,

 

I am handling a xlsx file to be loaded directly using Excel Query Component, but I would like to set all the columns to be string / varchar data type, not using by default detection.

So, how can I set it up to be None (treat everything as text). Thanks.

 

'By default, data types are guessed by looking at the cell formatting, not cell contents. This is controlled using the Connection Option "type detection scheme" which can be set to ColumnFormat (the default, which examines the cell formatting), RowScan (which will scan 15 rows of data and guess the data type based on the data values), or None (treat everything as text).'

2

You can use None ad below in Connection Options:

0694G00000SaEfOQAV_0D74G000009JMohSAG
0694G00000SaEfOQAV_0D74G000009JMohSAG840×129 3.46 KB

 

for more details you can check section TypeDetectionScheme in ttps://matillion-docs.s3.eu-west-1.amazonaws.com/datamodels/Excel.html#RSBExcel_p_TypeDetectionScheme.htm