Excel Binary .xlsb file headers special character automatically changed

[alt_tush]

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 :)

[TimN]

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

[binu_acs]

@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]

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.