Hi. I am trying to schedule a marketing cloud visitor ID report through data warehouse and when I get the excel file the ID is converted into a scientific format. I have tried to change format by using "Custom" format in excel however that results in multiple zeroes after a few digits. Also this report will be consumed as it is so can't really edit it every time before it is used. Any suggestions would be welcome.
Hi.
You mention that another team is going to consume this automatically. Are they going to be using Excel to check the data. The data only gets distorted when the file is opened in Excel. if the other team is not using excel, then they shouldn't have any issues.
If they are using Excel to check the data. You can probably use Report Builder. In that use the prepend function to avoid changing the value to scientific notation
Re: Report Builder keeps formatting numbers in Scientific/Text format
Regards,
Hyder
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.