According to your description,
anuj agrawal wrote:
I have two data tables which are identical in structure(column names etc).One is the current and the other is a reference table.
I suppose union would be better then data blend.
However, the decision of which function to use, depends on the specified data and requirements.
So please attach a sample workbook for more detailed advice.
Due to the tables being sensitive data i cannot attach workbook.
But for example
Table 1: Column A, column B, Column C, CalculatedField1, CaculatedField2
Table 2: Column A, Column B, Column C
As you can see both the tables are identical in structure. The only difference is that table 2 is updated at diferent point in time than table 1.
So im assuming I can just copy the calculated field into table 2 and hen compare using ATTR(Table1.CalculatedField1) = ATTR(Table2.CalculatedField1)?
1 of 1 people found this helpful
Two alternatives came to me, while I'm not sure if either of them works for you.
First, simply copy & paste the calculated fields from on data source to another.
Second, modify the data source (in which the calculated fields are created) and use union.
I tried copy pasting on another dummy data set and the calculations seemed to work. I guess ill try it in the main set and see what happens.I can take a union because my original two tables were comprsied from making unions and if i take another union I think ill have trouble with data repeating itself. Im guessing since the tables are going to be identical in structure, takin a blend and then blending on all dimensions might be easier.
The issue is that the calculated fields are really complex. Ive been working on them for 2 weeks now and taking a union might just throw a wrench to the workkbook. Thanks! ill keep you posted if it worked!
I just made the copy paste and used a blend on all fields. Worked for now but the thing is that both the tables wre an hour apart so might not be a change to flag. Ill keep this updated in case anyone has a similar question