Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Data

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:

   

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

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

Thanks,

Vince

6 Replies
maxgro
MVP
MVP

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;

1.png

Not applicable
Author

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

maxgro
MVP
MVP

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.

Not applicable
Author

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

MarcoWedel

please provide sample data to clarify.

regards

Marco

crusader_
Partner - Specialist
Partner - Specialist

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