Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Importing VARCHAR2(4000) from Oracle - truncation work around?

Highlighted
8 - Asteroid

I have an oracle table that has a VARCHAR2(4000) column and when I import it into Alteryx it gets truncated.

 

I have tried substringing the column into 200 Character segments and then used the Formula tool to concatenate the columns back together but Alteryx still cuts off the column at 256 characters.

 

E.g. Here are the column lengths:

 

ORIGINAL:      TESTO7,TESTP26,TE(787 CHAR) ...STP260,TESTP261...
IMPORTED:      TESTO7,TESTP2... (Truncated)
MERGED:        TESTO7,TESTP26,T (256 CHAR)
MERGED & TRIM: TESTO7,TESTP26,T (256 CHAR)

 

Questions:

  1. Why is Alteryx making the merged columns cutoff at 256 characters and is there any way around that?
  2. Is there anything else I can do?

 

This query, which I am importing is what I am using as my sample which mirrors my actual data:

 

SELECT CAST(CONDITION_1 AS VARCHAR2(4000)) "CONDITION1"
, CAST(SUBSTR(CONDITION_1,1,200) AS VARCHAR(200)) CONDITION1_01
, CAST(SUBSTR(CONDITION_1,201,400) AS VARCHAR(200)) CONDITION1_02
, CAST(SUBSTR(CONDITION_1,401,600) AS VARCHAR(200)) CONDITION1_03
, CAST(SUBSTR(CONDITION_1,601,800) AS VARCHAR(200)) CONDITION1_04
, CAST(SUBSTR(CONDITION_1,801,1000) AS VARCHAR(200)) CONDITION1_05
, CAST(SUBSTR(CONDITION_1,1001,1200) AS VARCHAR(200)) CONDITION1_06
, CAST(SUBSTR(CONDITION_1,1201,1400) AS VARCHAR(200)) CONDITION1_07
, CAST(SUBSTR(CONDITION_1,1401,1600) AS VARCHAR(200)) CONDITION1_08
, CAST(SUBSTR(CONDITION_1,1601,1800) AS VARCHAR(200)) CONDITION1_09
, CAST(SUBSTR(CONDITION_1,1801,2000) AS VARCHAR(200)) CONDITION1_10
, CAST(SUBSTR(CONDITION_1,2001,2200) AS VARCHAR(200)) CONDITION1_11
, CAST(SUBSTR(CONDITION_1,2201,2400) AS VARCHAR(200)) CONDITION1_12
, CAST(SUBSTR(CONDITION_1,2401,2600) AS VARCHAR(200)) CONDITION1_13
, CAST(SUBSTR(CONDITION_1,2601,2800) AS VARCHAR(200)) CONDITION1_14
, CAST(SUBSTR(CONDITION_1,2801,3000) AS VARCHAR(200)) CONDITION1_15
FROM ( SELECT 'TESTO7,TESTP12,TESTP13,TESTP14,TESTP15,TESTP16,TESTP17,TESTP18,TESTP21,TESTP22,TESTP222,TESTP224,TESTP225,TESTP23,TESTP24,TESTP247,TESTP248,TESTP249,TESTP25,TESTP250,TESTP251,TESTP252,TESTP253,TESTP254,TESTP255,TESTP256,TESTP257,TESTP258,TESTP259,TESTP26,TESTP260,TESTP261,TESTP262,TESTP263,TESTP264,TESTP265,TESTP266,TESTP267,TESTP268,TESTP269,TESTP27,TESTP270,TESTP271,TESTP272,TESTP273,TESTP274,TESTP276,TESTP277,TESTP278,TESTP279,TESTP28,TESTP280,TESTP281,TESTP282,TESTP283,TESTP284,TESTP285,TESTP286,TESTP287,TESTP288,TESTP289,TESTP29,TESTP290,TESTP291,TESTP292,TESTP293,TESTP294,TESTP296,TESTP297,TESTP298,TESTP299,TESTP300,TESTP301,TESTP302,TESTP304,TESTP305,TESTP306,TESTP307,TESTP308,TESTP309,TESTP310,TESTP312,TESTP313,TESTP314,TESTP4,TESTP5,TESTP6,TESTP7,TESTP8,TESTP9,TESTQ75' CONDITION_1 FROM DUAL)

 

 

 

Addendum:  My next step is to parse this column into individual rows.  I can't do it for the individual segments because I have probably cut values by the segmenting process, so I need to have the column combined into one big column before parsing.

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @Mark_Lurie,

 

When you look at the cells on the results window they are alwyas truncated. Don't worry about it.

 

You can add a browse tool after and you will see the whole information.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
8 - Asteroid

I guess I forgot to mention is my next step is to parse this combined column into separate rows.

 

When I do that I get truncated values so your recommendation doesn't help me.

Highlighted
8 - Asteroid

Thank you @afv2688, I was going crazy trying to figure out why the strings were getting cut off on the results window. I actually verified my output CSV files, and they are not truncated.

Labels