Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

error in powerBI using alteryx output

rbanola1
7 - Meteor

Hi team, 

I have a column named CLEAN_INV_NUM1 in alteryx workflow where fields are in the range of 7 to 5.585e+15 (in picture attached). My issue is that when i am trying to upload the data in powerBI then column CLEAN_INV_NUM1 shows error, i tried changing the data type of the column using select tool to "duoble" "V_string" and "fixed decimal" but nothing works. can anyone provide a solution or cause of this issue?

2 REPLIES 2
acarter881
12 - Quasar

Hello @rbanola1, I'm guessing that column comes from an Excel file. I've had this same issue and I solved my use case by using a few formulas. The first formula identifies if the cell has scientific notation (i.e., an "e+"). The two other formulas involve using REGEX_Replace and other functions. The data type should be string-related. Once you've cleaned the column, you may change it back to Double, for example. Basically, you want to ask yourself, "What does this number in scientific notation represent?" Then transform it into a non-scientific notation. An example is going from 3.5e+4 to 35000.

rbanola1
7 - Meteor

thank you

Labels
Top Solution Authors