Level 1 Model Building : Question on DATA01 Module
This question concerns part 11 of the Level 1 Model Building in Activity "Create a profit and loss model". I have a big import problem for the P&L+Actuals+&+Budget.csv because beyond the Actual,UK,Utilities line, nothing goes beyond that in the import (i.e. 2/3 of the data is missing in the import). I checked the validity of the data, the mapping and nothing solves my question. Has anyone encountered a similar problem and would they know how to help me?
Re: Level 1 Model Building : Question on DATA01 Module
Actually I think I solved my own problem. I realized I have not worked with data this large before and that not all data will show in the preview screen.
Also, because of the view I was in (probably could mess around in pivot to show everything), I was not seeing budget data since I had time as a column I had to scroll very far to the right to see the data.
So infact this was a good exercise in learning to double-check that your data is imported by paying attention to exactly how it imports and what view you are in.