Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fallenangel6
Creator
Creator

Data issue - lob,slob

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);

0 Replies