Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data pulled in via Connect In-DB appearing scrambled.

JamelTalbi
7 - Meteor

I'm having the strangest issue in that when I use a "Connect In-DB" tool to pull in data the values are showing up scrambled/gibberish. I have verified that the data in the actual database is intact via another querying tool so something seems to be happening with my connection from Atleryx. Has anyone experienced something similar/know what could be wrong?  Example attached. 

 

*I think the attached image may not be working correctly so here a is a copy/paste. There are two different columns here (legalname & add_mailingaddressline1) that are not parsed out, but you get the idea.

legalname  add_mailingaddressline1
Dalcvlddp Ajmnexavfjum- Wjtrzthlpvtc Wdwtcujwghigphht 86-10
Exhujvfkdiwvedqn Dlnsdpy TzoU Boupo-Tenss Declddp 19
LBA Edqn Ifjfqba LBA Exloglqj
Edqfd kls Unjrtsyj D.u.B. MZR Hjwsfnf 6 HFU
Edqfr Htqzrgnf DL Gravragr Trareny Cntg Kvtpunv Ujwts 461
Hwtfynf Edqnd kk A Qclyrpdl Lhgzmnuhbz 2
Kphtvuk Edqn Uqh Uqty 7 E Z D Ptr
Hwjinyt Nvrurjwx Wdasxcv Dzntpel' Ujw Bajpoj Mzr Nvrurj Dly Unjywt 7
Htsywfwnfs Hfunyfq Lzmzfdldms, I.I.H. 744 Pxlm Uzysfr Bwfovf
Mfcbjsreb Euhphq-Opse nP Treuneq Axquob Declddp 17-42
Ajroonrbnwkjwt Lzhm-Dapddlce nP Anlqcnwkjlqna Declddp 88

 

 

1 REPLY 1
BrandonB
Alteryx
Alteryx

Very strange indeed! What kind of database are you connecting to and what driver are you using? You can find more information about the supported data sources and driver information here: https://help.alteryx.com/current/designer/data-sources

Labels