Table becoming blank after transforming data

[favlucas]

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

[rubayatyasmin]

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.

[favlucas]

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

[favlucas]

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. 

[favlucas]

@rubayatyasmin you mean this button? 

[rubayatyasmin]

does it mean refresh? then yes

[favlucas]

Hi @mlsx4 

Actually this is a card, apart from the table just showing the quantity of itens that I have in this table. 

Thank you for your message, but I dont think this is the issue. 

[mlsx4]

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?

[favlucas]

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. 

[mlsx4]

Another thing, is the replaced id the link key with the table specialty? If so, public specialty should have replaced it too

[mlsx4]

Hi @favlucas 

You have some strange column which is shown (in blank). May the problem come from it?