Forum Discussion

oBi1's avatar
oBi1
Helper I
1 year ago

Dataflow: linked table doesn't update values - even with refreshing

Hi group

 

So I had another interesting issue pop up when updating a dimension table.

Let's say the table has 3 columns:
1) key

2) description

3) value

 

Originally one line shows:

1 - blank cell - blank cell (this is intended for n/a records in the fact)

 

I set up the FACT dataflow using the DIM as a linked table and a data file as a linked table as a basis for the final FACT.

Now I noticed the merge operation on 'description' field gave me only a small amoutn of matches. I checked and found that in the data file the description field is not blank but has "n/a" in it.

So I went back to my Dimension data flow and replaced the line with the blank description with:

1 - "n/a" - blank

 

I was expecting a lot more matches, but got no extra. Going back to the FACT dataflow, I found that the linked table still shows 

1 - blank cell - blank cell.

 

I tried multiple times refreshing both dataflows, restarting my computer even, but the linked table continues to show the original line. I even tried removing and adding back in the linked dataflow. 

 

What is going on? Hopefully someone has a clue!

 

Thanks

 

1 Reply