Data issue - lob,slob

[fallenangel6]

Hi,

PFA...

I have an issue that...

Emp:

LOAD Cluster,

     SBU,

     LOB,

     Sub_Lob,

     Age,

     Tenure,

     Level

    // 'Emp' as Flag

FROM

(ooxml, embedded labels, table is emp);

Join

Age:

LOAD Cluster,

     SBU,

     LOB,

     Sub_Lob,

     Age,

     engage as engage1,

     [not engage] as [not engage1]

  //   'Age' as Flag1

FROM

(ooxml, embedded labels, table is age);

Join

Tenure:

LOAD Cluster,

     SBU,

     LOB,

     Sub_Lob,

     Tenure,

     engage as engage2,

     [not engage] as [not engage2]

  //   'Tenure' as Flag2

FROM

(ooxml, embedded labels, table is tenure);

Join

Level:

LOAD Cluster,

     SBU,

     LOB,

     Sub_Lob,

     Level,

      engage as engage3,

     [not engage] as [not engage3]

   //  'Level' as Flag3

FROM

(ooxml, embedded labels, table is level);