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!
Sounds like you are on to something.
What happens if you format the data range as a table in the workbook?
As a temporary workaround, what happens when you prefix all values with the apostrophe (') forcing excel to recognize it as text?
Done for the day but will see about these this weekend.
For a work around I created 2 Workbooks and put all the numeric in 1 and all A/N in the other.
Created 2 Connections 1 for each workbook and set up the containers in each.
Created a Union report using 1 Subreport for the Numeric and 1 for the A/N
This worked.
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 Codes. Clicked the Text to Columns button which brings up a Wizard.
Click Next on Steps 1 & 2.
Step 3 change the Column Data Format to Text.
Click Finish.
Save the Workbook.
You my friend are a gentleman and a scholar. Thank you!
You're welcome. Also thanks to David for the apostrophe trick.
I would also put in a call to Support just to see what they say.
*Community Hub is the new name for Sage City