Skip to Content
avatar image
Former Member

Append Function Break the existing calculated Dimensions

Dear Experts,

I have faced one strange situation in 1.21 and not sure whether you see same issue in your side

I have data file structure like below

Country GSV

CN        1000

AU        100000

Then I create one calculated dimension called Region

The logic is, if country value  is NOT Equal to AU, then value is SA, else is NA

Then the result structure in Lumria is like below

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

Then I append another file with same original structure as below

Country GSV

KR        5000

so the value in Lumira becomes like this

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

KR        5000

At this time, I treat this is due to the formula cannot be recognized then I go to formula and click Edit and click ok

Result is still as below

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

KR        5000

Finally, I tried to click Refresh button and result is still no change

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

KR        5000

Please let me know your comment on this

Best regards

Alex yang

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 19, 2015 at 12:09 PM

    Hi,

    this definitely could be improved !!!

    Firstly,  I tried by defining an empty column 'Region' in the Append dataset, this made no difference

    if {Country} <> "AU" then "SA" else "NA"

    Secondly, i tried "Appending" the KR dataset, then adding the 'Region' if-then-else logic - this made no difference to target dataset.

    To conclude -  the only way you can do this, is to : "acquire" the 2nd dataset (don't Append/Merge yet..) then duplicate your logic in 2nd dataset.   Then Append into 1.

    regards,
    H

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2015 at 12:12 PM
    Add comment
    10|10000 characters needed characters exceeded