Alteryx Designer Desktop Discussions

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

Excel Binary .xlsb file headers special character automatically changed

alt_tush
9 - Comet

Hi,

I have small excel binary file which i want to run through desinger.

 

My excel headers are like FirstName,LN, Salary., Location. and Mid.Name

 

In my file some headers have special characters like dot (.)

But when i run this xlsb file using input tools my headers convert into Salary#, Location# and Mid#Name wherever the dot present in header.

Can you please assist me how can i fix this issue. I dont want to change the header. It should be same as Input file.

I am using Alteryx 2022.1.1 version.

 

Also please refer the attached image for reference. 

Appreciate your help :)

3 REPLIES 3
TimN
13 - Pulsar

Maybe change them back to "." in the workflow...

binuacs
20 - Arcturus

@alt_tush seems to be that is a non-ascii character, not a period(.), would you be able to upload a sample file with the same headings copied over?

alt_tush
9 - Comet

Hi,

My issue is resolved. I have tread xlsb header as data and then i used dynamic rename and selected the rename mode as "take field name as first row of data" and it works :)

 

Thank you all for your support.

Labels