
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Problem in Data Load Editor
Hello fellows,
I am trying to figure out a dashboard which was created by a former colleague.
She coded everything in the dateneditor, but when I run it, it does not work.
I get the following message:
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The table having 49 fields while the source only has 43 isn't neccessarily a problem. It could just mean that some fields from the source are used more than once to create a field in the QS table.
It is important that the spelling of the field in the source is the same as in QS. "field", "Field" and maybe "Field " are not the same.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sound like your colleague used a Load * From [...]; to load all contents of a file, including the 'Marker manuelle Zuordnung Portfolio & Segment' field. I would assume that the reason the field cannot be found is because the source file was changed and the field either removed or renamed.
Check where the field is first mentioned in the script and try to figure out, where the data comes from and make sure the field is included and spelled correctly in the data.
Since you completely removed the field from the data model, all visualizations relying on it are broken.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I go to the data where these field comes from but these field is not there to be found... 😞
According to the data load editor there should be 49 fields, but instead the table from where the information comes from has only 43 fields.
What I find funny, is that for the year before a dashboard just like this one was done, where also the data load editor shows 49 fields, but the original table has 43 fields.... but in this case, I can load the data with no problem and everything works fine.... a mistery

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The table having 49 fields while the source only has 43 isn't neccessarily a problem. It could just mean that some fields from the source are used more than once to create a field in the QS table.
It is important that the spelling of the field in the source is the same as in QS. "field", "Field" and maybe "Field " are not the same.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the solution, thank you for your support!
