Mathematical comparison between same attributes names of two different data-set
Mathematical comparison between same attributes names of two different data-set based on placement of the attributes. I have 24 attributes each in two data sets, i need to do calculation from first dataset 1st attribute against 1st attribute of second data set. I don't want to pick the attribute name hardcoded, but i need it dynamic as the month name will differ from time to time.
Consider the attached dataset as both datasets(same attribute but different values)
I need to do calculation in 1st attribute (multiply, divide, etc) and compare the value of the same attribute in second dataset. Hope the requirement is clear. Im trying to make this as dynamic as possible. The placement of the attributes in exactly the same in both dataset(along with exact same name)
Looking forward to hearing from you all. Thank you.
Consider the attached dataset as both datasets(same attribute but different values)
I need to do calculation in 1st attribute (multiply, divide, etc) and compare the value of the same attribute in second dataset. Hope the requirement is clear. Im trying to make this as dynamic as possible. The placement of the attributes in exactly the same in both dataset(along with exact same name)
Looking forward to hearing from you all. Thank you.
Find more posts tagged with
Sort by:
1 - 2 of
21
Sort by:
1 - 1 of
11
If I understand your requirements correctly, I think the best way would be to transpose the dataset so that Months are your row indexes and your attributes represent YearMMc. Then you can compare and calculate on the rows through the same indexes by using the operator 'Filter Example Range'.
Another way if your database is consistent in terms of the number of months in both datasets is by using the operator 'Rename by Generic Names' to have attributes name represent the column indexes. This way you can have consistent attributes name for comparison between datasets.
What do you think will be a better approach for you?