Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center 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.

 

 

 

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.

Labels