Import Percentage

Question

Hello!

I am importing a Netsuite file that has a percentage field.  The CSV that comes out of Netsuite has the field formatted like this: 100.00%.

Because Alteryx recognizes that its a number, I cannot do string transforms on it (such as trimming the %), even after using the Select tool to try and make it a String.  Because it has a %, it always gives the error "Lost in translation".

So far, it works despite that error (100% gets converted to 100, which I then divide by 100 to get 1), but it's messy and I don't like conversion errors.

Is there a best practice for importing weird percentages like that, or perhaps a Tool I'm missing?

apathetichell · Answer

Hi - could you post some data as .txt, .csv or something like that? I think part of the problem may be you are converting things in a select tool - that usually doesn't work great...

CSmithAltus · Answer

This is exactly what I attempted, but when I attempted to Trim the column with the Formula tool, it gives me a Type mismatch error, stating it needs to be a String, despite the fact that I have used the Select tool to make that field a String.

Christine_Assaad · Answer

Hi @CSmithAltus

I believe with the %, the data will come thru as a string field. You can then use the Trim function to get rid of the the % sign. Once done, with a Select, you can change it to double or fixed decimal. Hope that helps. If not, perhaps a sample dataset would help. Cheers!