Getting Problem with Interval Match() Can any one Give a Proper Solution?

[sgg_gaikwad]

Layout:

LOAD LineNum,

     Type,

     Description,

     [GL Account Start] ,

      [GL Account End] ,

     [Total Start],

     [Total End],

     Sign

FROM

(ooxml, embedded labels, table is PAndL);

PLData:

LOAD //Period,

     Date,

     GLAccount,

     Office,

     Amount,

     AccountType

     //F7

FROM

(biff, embedded labels, table is [Data$]);

IntervalMatch(GLAccount)

LOAD

[GL Account Start]  &  [GL Account End] as GLStartEnd Resident Layout;

[MK_QSL]

Change

IntervalMatch(GLAccount)

LOAD

[GL Account Start]  &  [GL Account End] as GLStartEnd Resident Layout;

to

Final:

IntervalMatch(Date)  Left Join Load [GL Account Start] , [GL Account End]  Resident Layout;

Left Join (PLData) Load * Resident Layout;

Drop Table Layout;

[manideep78]

Try This

IntervalMatch(Date)

LOAD

[GL Account Start]  ,  [GL Account End]  Resident Layout;

[sgg_gaikwad]

Hi Manish,

                    Thanx for Reply Its working..

But,I don't want single table in Data Model I need Three Different table in Data Model...

[sgg_gaikwad]

Hi Manideep,

                    It is creating a Synthetic key in Data Model &  i need Three Separate table in Data Model..

[MK_QSL]

Remove

Left Join (PLData) Load * Resident Layout;

Drop Table Layout;

add

Left Keep (PLData) Load * Resident Layout;