why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order?
Excel Output Connector Module Sample Run Original Excel FIle Import
why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order?
Excel Output Connector Module Sample Run Original Excel FIle Import
Sounds like maybe somewhere, the item code column's data type is being automatically assumed to be numeric based on the first x number of rows and it is thinking the alphanumeric values are failing the…
Change the data to a Table still have the issue.
Did the apostrophe just for the Numeric values and that worked.
Easier way is using the Text to Columns on the Data Ribbon.
I highlighted all of the Item…
You my friend are a gentleman and a scholar. Thank you!
*Community Hub is the new name for Sage City