Forum Discussion
Empty columns
Hello FrisoW,
It is very difficult to judge without going through the issue or logistics. Can you provide a sample file or the steps in the query editor for the table?
Maybe it would be little helpful to understand the issue.
Hi rajulshah,
I understand. I'll try elaborate because I won't be able to provide a sample file as the problem is limited to my project and this contains confidential data.
1. Get data, source is Dynamics CRM
2. Transform data
3. In query editor, I have 5 columns, with 0 blanks in all 5 columns and over 30000 rows
4. I close the query editor
5. I open the data view, 3 columns are completely empty
6. Also when I create a table in the report view, the columns are blank
I tried deleting the table and adding it again, but the same 3 columns remain empty.
No relatingships have been set yet.
This must be a bug?
FrisoW, Can I see the screenshot of the transformation steps?
OR
You can do 1 thing : You can filter the blank values and then 'Close & Apply' the changes and see what you can see?Transformation steps:
Source
Navigation
Removed Other Columns (all but those 5)
Filtered blanks in statuscode_display column, all 30000 values appeared.
Other columns remained empty, so filtered those as well. All values appeared.
This makes completely no sense but you managed to solve it anyway, thanks a lot!
Hi FrisoW ,
It seems that you have resolved the issue. Please accept the helpful answer as a solution. More people who have the same problem will benefit from the thread.