Forum Discussion
Resident RockstarExcel data changing format upon upload
Looking at your code, I see that your Excel Import includes Kind = Sheet. If you have this in Table format in Excel, then you can change that code to Item = "Table Name", Kind = Table]. If your data is not in table format in excel, then you can turn it into a table by selecting the excel table and pressing CTRL+T. If the info is in this current workbook, then Get data from Table/Range will do this automatically. Honestly, though, I never considered whether or not coulmn names respect date formats or data types.
Wait though, can[t you make these columns type text, and then promote headers? Once you do that, and then promote headers, you cna always go back and change the type.
--Nate
Looking at your code, I see that your Excel Import includes Kind = Sheet. If you have this in Table format in Excel, then you can change that code to Item = "Table Name", Kind = Table]. If your data is not in table format in excel, then you can turn it into a table by selecting the excel table and pressing CTRL+T. If the info is in this current workbook, then Get data from Table/Range will do this automatically. Honestly, though, I never considered whether or not coulmn names respect date formats or data types.
Wait though, can[t you make these columns type text, and then promote headers? Once you do that, and then promote headers, you cna always go back and change the type.
--Nate
- StefanoGrimaldi
I tried making them text no the excel file didnt work, set them as text column on the BI same it failed when promted the header xD,
it did work the option you mention of converting it to a table on the excel,thanks.the change type on dataflow option didnt work cause it was making the change on the import step,althought I solved this with your comment, still would be nice to find about this behaviour why it does it and how to control that on the import o.0 !!!!
