Forum Discussion

davidwhite83's avatar
davidwhite83
Frequent Visitor
6 years ago
Solved

Power Query CSV File is not in a usable format

    I am currently working with a CSV file that our company recieves where portions of the data are not on the same row as the invoice number, date, and other information. If it was a small file I ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi davidwhite83 
    One more step. In those columns that have blanks rather than null, you have to highlight the column and perform Find and Replace. Leave the Find box empty and then type null into the lower box. All lowercase, no quotes. This should do it.  What is strange is that just typing it into your source table does not work.  Let me know how this goes.


    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

davidwhite83's avatar
davidwhite83
Frequent Visitor
6 years ago

It works on the number portion of the file but not with names.

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi davidwhite83 
One more step. In those columns that have blanks rather than null, you have to highlight the column and perform Find and Replace. Leave the Find box empty and then type null into the lower box. All lowercase, no quotes. This should do it.  What is strange is that just typing it into your source table does not work.  Let me know how this goes.


If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel