Forum Discussion

Ganira's avatar
Ganira
Regular Visitor
4 years ago
Solved

Power query - changing entries and Big Data

Hello, everybody.   I have CSV files that upon opening have some irregular IDs' entries (all IDs should have 17 characters but after filtering them by length I found some that had an irregular amou...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Question 1:  Power Query is messing with you and (wrongly) guessing column types. Tell it to not do that (in the options)

     

    Question 2:  Whatever you are more comfortable with. Could be VBA, could be Power Query, could be the data model/DAX.  Try it out.

lbendlin's avatar
lbendlin
Super User
4 years ago

Question 1:  Power Query is messing with you and (wrongly) guessing column types. Tell it to not do that (in the options)

 

Question 2:  Whatever you are more comfortable with. Could be VBA, could be Power Query, could be the data model/DAX.  Try it out.

  • Ganira's avatar
    Ganira
    Regular Visitor
    4 years ago

    Thank you so so much! 🙂