Forum Discussion
Table becoming blank after transforming data
Hello Guys! Im having an issue for a while that I can not fix it.
I have a table below where a colun has some values. The values are either blank or appear a data for me.
When I go to transform data and replace blank for "DETACHED" for instace, all the information disappear of my table. check the step by step below
It also happens when I need to add a colum.
Thank you so much!!!!step 1 - how is my tablestep 2step 3step 4 - replacing valuesstep 5step 6 - how my table is after update
11 Replies
rubayatyasminCommunity Champion
Hi, favlucas
Can you check that your values are exactly null? Is it possible that the blanks in your data aren't really nulls or blanks? They might be a non-printing character or space. In such cases, the above-mentioned steps will not work.
if its a space you need to put space in the value to replace the field.
Hi rubayatyasmin thank you for your contribuition.
The issue is not related to replacing the blank on the field, this point aleady done.
The point is when I replace it, my table does not appear any information anymore, even with any filter.
- rubayatyasmin
Tray data source refresh after loading.
Hello guys, I will post another example that might be better to understand.
When I add a colum, as below, my table does not appear the data anymore;
My table before adding a columnI click on transform dataselect the tablethen I click on add columnn based on delivery data, to show me the name of the daythis is my database after that, everything is right so farthen, when I click on close and apply and go back to my table, every information is gone
mlsx4Memorable Member
Okey favlucas . And have you checked any possible filter that could be active?
And if you start now constructing another table in a empty page, do you have the same problem?
Also, I suppose you are using a measure or a later step to rename all specialties... Have you checked it too?
Thank you mlsx4
I checked the filters and it is not the case as well.
When I excluded the table and created other, some informations that are related to other tables comes in blank for me, even though the relations among the tables are active. please, check below:
The columns above that are in blank are client name and specialty name, respectively.
