topic Re: Generate a table from other retreived data in QlikView

Generate a table from other retreived data

rennesia — Mon, 07 Mar 2016 12:45:05 GMT

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)

Re: Generate a table from other retreived data

petter — Mon, 07 Mar 2016 13:19:36 GMT

Is this some load script that is working?

Re: Generate a table from other retreived data

sunny_talwar — Mon, 07 Mar 2016 13:47:37 GMT

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.

Re: Generate a table from other retreived data

pooja_sn — Mon, 07 Mar 2016 13:50:15 GMT

What fields does table 'BatchData' contain? can you share your qvw?

Re: Generate a table from other retreived data

rennesia — Mon, 07 Mar 2016 15:30:14 GMT

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

Re: Generate a table from other retreived data

gferran — Mon, 07 Mar 2016 16:04:27 GMT

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.

Re: Generate a table from other retreived data

rennesia — Tue, 08 Mar 2016 07:17:09 GMT

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.