Creating Data

[#1]

Hey All,

I am trying to produce a table, where one of the columns are fabricated, and I am not sure if it is possible.

In my example I have Slot and Reactor - both of which are related in the data (though they come from different QVDs) and can be put in the table. In the example the red field is what I am trying to add - it is always five weeks later than when Reactor sits:

Slot	Reactor	Purification
01/05/15
01/12/15	Product 1
01/19/15
01/26/15	Product 2
02/02/15
02/09/15	Product 3
02/16/15		Product 1
02/23/15
03/02/15	Product 4	Product 2
03/09/15	Product 5
03/16/15	Product 6	Product 3
03/23/15
03/30/15
04/06/15		Product 4
04/13/15		Product 5
04/20/15	Product 6

I hope this makes sense to someone else, and is do-able.

Thanks,

Vince

[maxgro]

try this

SET DateFormat='MM/DD/YYYY';

a:

LOAD Slot,

     Reactor,

     Purification

FROM

[https://community.qlik.com/thread/178335]

(html, codepage is 1252, embedded labels, table is @1);

left join (a)

load

  date(Slot+35) as Slot,

  Reactor as PurificationCalc

Resident a;

[#3]

The problem is that slot and and reactor are from different tables so I do not know how to load them together.

[maxgro]

You need one or more common fields to join the two tables when you load the 2 qvd files.

Then, when you have one table, apply my script.

If you can, post the 2 qvd and explain how they are related.

[#5]

They link to one another through a third table and separate fields

[MarcoWedel]

please provide sample data to clarify.

regards

Marco

[crusader_]

Hi Vincent,

It's not a problem in fact.

If you matched these fields in your mind or in Excel spreasheet QlikView is able to do it as well.

Please provide more information or ER-diagram. It helps us to suggest a solutions for you.

Regards,

Andrei