Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following problem:
From several tables I read data and I have to combine it to one new table BatchData. What is the correct script to realize that?
When someone has a
Batch_Actual:
LOAD
Val as Actual_StartYear;
SELECT * FROM x WHERE Name = "Actual_StartYear";
join(Batch_Actual)
LOAD
Val as Actual_StartMonth;
SELECT * FROM x WHERE Name = "Actual_StartMonth";
join(Batch_Actual)
Batch_Previous:
LOAD
Val as Previous_StartYear;
SELECT * FROM x WHERE Name = "Previous_StartYear";
join(Batch_Previous)
LOAD
Val as Previous_StartMonth;
SELECT * FROM x WHERE Name = "Previous_StartMonth";
join(Batch_Previous)
BatchData:
=(Actual_StartYear),=(Actual_StartMonth)
=(Previous_StartYear),=(Previous_StartMonth)
Is this some load script that is working?
Not idea what the intention is. May be if you can provide some sample data with the expected output, it would be easy to understand.
What fields does table 'BatchData' contain? can you share your qvw?
Petter and Sunny, thanks for the replies.
Yes, this script is a load script.
An example:
Batch_Actual.Actual_StartYear = 2016
Batch_Actual.Actual_StartMonth = 03
Batch_Previous.Previous_StartYear = 2015
Batch_Previous.Previous_StartMonth = 04
BatchData (the new table) must be:
2016,03
2015,04
To combine diferents tables the join operation is the right way but you must know than the default join is the outer. Try to explain your intention to permit our help.
Maybe more explanation is useful...
I have to read several data from one table (as you can see by Batch_Actual and Batch_Previous). That data must be copied to another table, so I can use it for presentation etc.
In the script from the attached file, you can see at the 'New BatchData'-tab the layout of the table I have to realize.