Load column with newline character from Excel to Snowflake by using Excel Query

Matillion ETL
1

I am trying to load data from the column with the newline character ("Column\n1") from Excel to Snowflake by using Excel Query. Is it possible?

2

Hi @tomasz.jakub.sroka​ and thanks for posting!

It should be possible using the Excel query component.

1: Switch to Advance query mode from Basic.

2: Rewrite the SQL with column alias as mentioned in sample SQL.

SELECT

"column

1" as "column\\n1",

"column

2" as "column\\n2",

"column

3" as "column\\n3"

FROM

"Sheet1"

Let me know if that helps at all!

Many thanks,

Claire

3

Hi Claire,

 

I tried a few different syntaxes:

1)

SELECT

"Column

1" AS TEST

 

2)

SELECT

"Column

 

1" AS TEST

 

3)

SELECT

[Column

1] AS TEST

 

4)

SELECT

[Column

 

1] AS TEST

 

But all the above syntaxes are not working.

4

Hi @tomasz.jakub.sroka​ and thanks for your response. I'm sorry to hear they haven't worked. There may be more here than I can see. Could I ask that you put in a support ticket so that the team can take a further look?

Many thanks,

Claire