Scientific Format In Data Warehouse Report

Avatar

Avatar

vipuls85671841

Avatar

vipuls85671841

vipuls85671841

08-02-2019

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.

View Entire Topic

Avatar

Avatar

vipuls85671841

Avatar

vipuls85671841

vipuls85671841

04-03-2019

Hi hyderziaee​. Tried using Report Builder but since I need this MID data correlated with pages and various events as metrics, the limitations with Report Builder do not let me get entire data. Since only Data Warehouse can be used to extract the report is there a way to get MID in the correct (non-scientific) format?