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