Results 1 to 3 of 3

Thread: Column contains Null instead of Content in combine & Transform

  1. #1
    Seeker akephart's Avatar
    Join Date
    Oct 2016
    Location
    Nanaimo
    Posts
    11
    Articles
    0
    Excel Version
    365

    Column contains Null instead of Content in combine & Transform



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Using Excel I used Get Data to import from a folder two excel (.xls) files. During the transform process I have multiple columns. One of the columns can have a number or text (data entry issues). The text is returning a null because I'm assuming the first number that power query comes across is a number. Usually I can solve this by forcing the column to be text. But this time I can't seem to figure it out. For now I'm just modifying the original import file and fixing the data entry issue but I would really like to fix my import so I don't have to. I've attached some examples that will hopefully make clear what I'm trying to accomplish.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Text Example.jpg 
Views:	10 
Size:	6.1 KB 
ID:	9709   Click image for larger version. 

Name:	Number Example.jpg 
Views:	10 
Size:	6.1 KB 
ID:	9710   Click image for larger version. 

Name:	Text Error Example.jpg 
Views:	12 
Size:	19.8 KB 
ID:	9711   Click image for larger version. 

Name:	Power Query Steps.jpg 
Views:	11 
Size:	51.9 KB 
ID:	9712  

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    225
    Articles
    0
    Excel Version
    2019
    Really difficult to analyze from a picture. Suggest you upload your file after you have sanitized it for confidential data. In this manner, we can do a full analyzation.

  3. #3
    Acolyte NormS's Avatar
    Join Date
    Jul 2017
    Posts
    92
    Articles
    0
    Excel Version
    Excel 2016 ProPlus
    Have you tried disabling automatic detection of column types and headers in query options?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •