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.
SOLVED

Removal of E error in text

Highlighted
7 - Meteor

We have several records that contain field data of "30E33" that when uploaded will changes into "3.00E+34".  I need to find a Cleansing Tool that will recognize the error and correct during my workflow.  Please Note: I am not at liberty to change the offending data prior to upload.

 

Currently I manually change the data for all my reports but would love to find a tool that can help.

 

Any ideas, warmly welcomed ! 

Highlighted
Alteryx Certified Partner

Hi @KSassone ,

 

Where do you get this data from? Do you have a sample of your dataset for me to check all possibilities?

Do you want to keep the 30E30 as it is, right? To keep as text or to keep as a number 30E30?

 

Best,

Fernando Vizcaino

7 - Meteor

Hi Fernando,

 

Sample data attached.  Yes I need to keep the examples as text, and not the automated excel error result.  I know what excel is doing, but I want to clean the data prior to input into my workflow process as I cannot change Location text.

 

Any help, very much appreciated !

Kindest regards,

Kiri Sassone

Highlighted
Alteryx Certified Partner

Hi @KSassone ,

 

 

I'm attaching a not so elegant cleansing to the problem you're having.

Since I'm not sure if all your rows presents the same problem, I added a statement to leave as null other occurrencies.

 

Best,

Fernando Vizcaino

Highlighted
7 - Meteor

Thank you for this!  I have come across a version issue as it looks like we are still on an earlier version of Designer. I will need to download the latest version to view your file! 

Highlighted
Alteryx Certified Partner
Hi,

There is no need for that. You can change the workflow format temporarily
to xml and change the first or second line where it says the alteryx
version. You can insert yours or lower. Then change it back to yxmd

Best,
Fernando V.
Highlighted
7 - Meteor

I think this will work - Thank you !!  Will test it out this weekend and reach out again if I need further clarification !


Thank you !!

Labels