Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Appending Queries

Hi All,

 

I have 2 facts Fact1 and Fact2

when i try to Append Fact2 to Fact1 i am loosing values

For Ex: i have Fact2(MonthKey,Units) 

If i drag Units from Fact2 then i get 3099M

and when i drag from appended one Fact1(Fact1 Appended with Fact2) i get 3066M

can anybodey tell me what could be the reson,why because this appending does not respect any of union rules as far as i understand(number,order & Data Type of columns).

 

Thanks in advance

Need Help

4 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    9 years ago

    Anonymous I think its because when you append for the same columns values also get appended (ie duplicate values are replaced by one) and so duplicates are removed that is why you're getting lower count after append.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi ankitpatira,

      thanks for the reply.

      but i have a column in both the facts which will differentiate them 'Fact Type'

      Fact Type = Fact1

      Fact Type = Fact2

      for every row in the both the facts.

      still, is there a chance of duplicates..??

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        and yeah just now i calculated countrows on both the facts,

        Fact1(Appended with Fact2) with visual filter fact type = fact2 and Fact2.

        countrows(fact1) = 39815

        countrows(fact2) = 39815

        revenue from fact1 = 3099M and

        revenue from fact2  = 3066M 

        count of rows are the same but measure values are different.

        what did i miss?

        please let me know if anybody has any idea.

        thanks in advance.