Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Script:
[Table 1]:
Date(DateA) AS DateA,
Balance,
[Table 2]:
Date(DateB) AS DateB,
Target,
I'm trying to get a straight table which shows:
Date | Balance | Target
Thanks for your help,
Darren
All you need to do is to name the two dates the same, e.g.
Date(DateA) AS Date,
Date(DateB) AS Date,
HIC
Hi,
If possible you can concatenate two tables like below:
Output:
LOAD
Date(DateA) AS Date,
Balance,
........
Concatenate(Output)
LOAD
Date(DateB) AS Date,
Target,
Then in a straight table add Date as dimesion and use Balance & Target in expression.
Regards,
Som
Ideally, I was hoping for an expression which may solve this.
I can't rename the fields to be the same as this would cause a loop
Try the following script:
TempOutput:
LOAD
Date(DateA) AS Date,
Balance,
........
Concatenate(Output)
LOAD
Date(DateB) AS Date,
Target,
Output:
NoConcatenate Load Date, Sum(Balance) as NewBalance, Sum(Target) as NewTarget
Resident TempOutput Group By Date;
Drop table TempOutput;