Convert Account Number to General Format in Excel to allow Vlookup

Question

Hello Reader,

I have few account numbers as below in my output.

1010000000

131210005I

299110000L

1110000A00

When extracting to excel as output, the datatype is V_W String. However, this is creating vlookup issue for user and they need to first convert it into number format and then apply vlookup.

Is there a way in alteryx to solve this problem?

I tried to convert it into double format but this deletes the letter inside the 10 digit account number, giving incorrect data like

131210005I

299110000L

1110000A00

ankush-agrawal · Answer

Komal, it is the other way around.

My output is from Alteryx to Excel and then I am using the excel for other different purpose. So, rather than manually changing the data type in excel, I will prefer something if available in Alteryx for this and user can directly work on it, rather than spending time.

ankush-agrawal · Answer

I get the general format in excel, let me show you sample.

U can see the example of Account 1010000000.

One is after converting to Number and other is before (with some Green Mark at the top right, meaning the data is in text format)

This is not good for vlookup.

image.png

Komal_singla1 · Answer

before doing vlookup convert the data from number to text using text to column in the original excel file and then try