topic How do I... in QlikView

How do I...

samvile18 — Wed, 09 Jan 2013 12:45:05 GMT

...create a table within my script which contains two fields from two other tables??

I have two tables, one called SchemeDimensions and the other called QVDataCombined. I want to create a third table based on fields from these two.

The fields I have are as follows: SchemeDimensions - EmployerId

QVDataCombined - StagingDate

I need to create a third table that shows every StagingDate for each EmployerId.

Can anyone out there please help?

swuehl — Wed, 09 Jan 2013 12:59:58 GMT

I need to create a third table that shows every StagingDate for each EmployerId.

So you want a result like a cross product of these two?

Maybe like:

SchemeDimensions:

LOAD * INLINE [

EmployerId

];

QVDataCombined:

LOAD * INLINE [

StagingDate

01.01.2013

02.01.2013

03.01.2013

];

RESULT:

NOCONCATENATE LOAD DISTINCT

EmployerId

Resident SchemeDimensions;

JOIN LOAD DISTINCT

StagingDate

Resident QVDataCombined;

samvile18 — Wed, 09 Jan 2013 13:16:27 GMT

Excellent, thanks for the help....again!!