topic Data issue - lob,slob in Connectivity & Data Prep

Data issue - lob,slob

fallenangel6 — Tue, 23 Oct 2018 16:39:41 GMT

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