How do I...

[samvile18]

...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 · Accepted solution]

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

1

2

];

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]

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