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 :)
@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?
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.