Forum Discussion
DataFormat.Error when using Table.ExpandListColumn()
Most Valuable ProfessionalSince you are expanding SalesPeriod column, hence error message you should get in that column. But before that make sure column profiling based on entire data set is set.
When I change the setting to "column profiling on entire data set" i get an unexpected error 😓
- Vijay_A_Verma
Click on one of the errors and post the message text (not picture so that I can use Google translate).
there is no more message text. When I change the setting it starts computing, then it stops and only displays as on my screenshot. Maybe my computer just cant process the the profiling based on the entire data?
- Vijay_A_Verma
Insert one index column.
Apply filter for <=2000
Then change the column profiling setting.
Then check for error message.
If error doesn't come, apply filter >2000 and less than 4000...And so on to check for error message in chunks of 2000. When you first encounter it, then do the analysis.