Table Merge

Question

Hello!&nbsp;I have a fact table and value table that I'm having trouble merging&nbsp;Fact TableRepService Line&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mike Sanchez&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;27607/13/21Henry Honcho34907/12/21Billy Skywalker24207/12/21&nbsp;Value TableService Line&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value Units&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2760503490202420101738100&nbsp;My goal is to be able to visualize the value derived from each rep over a given period of time.&nbsp;I tried to add a value column to my fact table, but the merge function wouldn't recognize 'Value Table'[Service Line] &amp; 'Fact Table' [Service Line].&nbsp;Is there another way to do this I could try?&nbsp;Are there any other ways to achieve my goal without combining the two tables?&nbsp;Thanks everyone! Your help is tremendously appreciated!!&nbsp;

aj1973 · Accepted Answer

Hi&nbsp;mccollough&nbsp;Your Model should look like thisAdd Column to have this&nbsp;

Forum Discussion

Table Merge

2 Replies

Related content

Merge Summarize Table

Snowflake Tables Not Merging in Service

Merge table in loop

merge or update/insert lakehouse table from another lakehouse table

MERGE QUERIES

Rep	Service Line	Date
Mike Sanchez	2760	7/13/21
Henry Honcho	3490	7/12/21
Billy Skywalker	2420	7/12/21