Excel Binary .xlsb file headers special character automatically changed

Question

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

20240105_224809.jpg

20240105_224751.jpg

alt_tush · Answer

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.

binu_acs · Answer

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

TimN · Answer

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

Changeback.yxmd