View not updating

Options

I have a view of two data sets that are left joined. For some reason one of the columns shows blank for one of the columns in the joined data set view. The weird thing is that it's only for certain rows.

I have checked different filters and looked around to see if there was a refresh button. With no luck.

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @Josh_Evans20 Is the column with blank values coming from the right table in your join? If so, check whether that value for your join key exists in the right table. If there is no match found in the right table, then any column that comes from the right table will be null for those rows.

    In the example below, assume you want to join the left table to the right table on Customer. The right table does not have a row corresponding to the customer "ABC", so there is no Sales for that customer in the output.

    As a side note, dataset views update when their input datasets update which is why you don't see a refresh button.

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @Josh_Evans20 Is the column with blank values coming from the right table in your join? If so, check whether that value for your join key exists in the right table. If there is no match found in the right table, then any column that comes from the right table will be null for those rows.

    In the example below, assume you want to join the left table to the right table on Customer. The right table does not have a row corresponding to the customer "ABC", so there is no Sales for that customer in the output.

    As a side note, dataset views update when their input datasets update which is why you don't see a refresh button.