Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am unable to show same EMPNO values into one row.
EMPNO2 has two rows in the screen. But I want to show in a single row.
How to achieve this?
Please help.
Thanks in advance.
Hi Digvijay
Yes, I am combining Dimension table and measure value tables as shown in datamodel EMP,SAL,COMM tables.
Please help me. Thanks in advance.
Hi,
Try this script to fix the DEPTNO issue
DEPT:
LOAD DEPTNO,
DNAME
FROM
EMPLOYEE.xlsx
(ooxml, embedded labels, table is DEPT);
EMPDEPT:
LOAD DISTINCT
EMPNO,
DEPTNO
FROM
EMPLOYEE.xlsx
(ooxml, embedded labels, table is EMP)
WHERE Len(Trim(DEPTNO)) > 0;
EMP:
LOAD EMPNO,
ENAME,
JOB,
DATE(HIREDATE) AS HIREDATE,
DATE(LASTDATE) AS LASTDATE,
INCHARGE2,
INCHARGE1
FROM
EMPLOYEE.xlsx
(ooxml, embedded labels, table is EMP);
LEFT JOIN
SAL:
LOAD *,QUARTER &'-'&YEAR AS QUARTERYEAR;
LOAD EMPNO,
YEAR,
MONTH,
QUARTER,
DATE(STARTDATE) AS STARTDATE,
SAL
FROM
EMPLOYEE.xlsx
(ooxml, embedded labels, table is SAL);
COMM:
LOAD YEAR,
'Q' & QUARTER AS QUARTER,
EMPNO,
COMM
FROM
EMPLOYEE.xlsx
(ooxml, embedded labels, table is COMM);
Temp:
LOAD INCHARGE1 AS EMPNO,
SAL AS INCHARGE1SAL,
QUARTERYEAR
RESIDENT EMP
WHERE Len(Trim(INCHARGE1)) > 0
;
Temp:
LOAD INCHARGE2 AS EMPNO,
SAL AS INCHARGE2SAL,
QUARTERYEAR
RESIDENT EMP
WHERE Len(Trim(INCHARGE2)) > 0 or ISNULL(LASTDATE)=-1;
Regards,
jagan.
Also I noticed that there are lot of Synthetic keys in your app, it is not a good practice to have Synthetic keys in the Datamodel.
Hi jagan,
I tried with your script. But it is not working in original application.
It should work, copy the whole script and then try to reload.
Regards,
jagan.