Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below the datasource from oracle table . Noticed that there are this row 5, and 6 with red color , are duplicates. How am i suppose to display all the rows in straight table . The script and expression is as below :
NPDScript:
select FORM_ID,EMP_NO,EMP_NM, PROD_NM,SITE,ACTIVITIES,ACT_DATE,MANHRS,TIMESHEET_DATE,APPROVEDDATE,TOTAL_COST,PHASE FROM timesheet_npd order by approveddate ;
NoConcatenate
Load FORM_ID,EMP_NO,EMP_NM as emplyeenames,PROD_NM,SITE,ACTIVITIES, ACT_DATE,MANHRS as manhrs_npd,TIMESHEET_DATE, floor(APPROVEDDATE) as appDates,TOTAL_COST,PHASE
Resident NPDScript;
Drop table NPDScript ;
Expression :
if(appDates >=vStartDate and appDates <=vEndDate,appDates,0)
EMP_NO | EMP_NM | DATE_FROM | DATE_TO | CODE | PROD_NM | ACT_DATE | ACTIVITIES | MANHRS | APPROVEDDATE | APPROVED | SITE | BUDGETED_HRS | TOTAL_COST | TIMESHEET_DATE | PHASE | ||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Amlodipine Tablets 5mg | 27-Mar-19 | Review report- Assistant Managers & above | 2 | ########### | Y | PMB | 230 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Bisoprolol Tablets 2.5 mg | 27-Mar-19 | Analytical Method Validation (AMV) protocol | 3 | ########### | Y | PMB | 345 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Bisoprolol Tablets 5 mg | 29-Mar-19 | Analytical Method Validation (AMV) protocol | 3 | ########### | Y | PMB | 345 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Bisoprolol Tablets 10 mg | 29-Mar-19 | Analytical Method Validation (AMV) protocol | 3 | ########### | Y | PMB | 345 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Irbesartan Tab 300 mg | 25-Mar-19 | Analytical Method Validation (AMV) protocol | 1 | ########### | Y | PMB | 115 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Irbesartan Tab 300 mg | 25-Mar-19 | Analytical Method Validation (AMV) protocol | 1 | ########### | Y | PMB | 115 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Amlodipine Tablets 10mg | 25-Mar-19 | Analytical Method Validation (AMV) protocol | 2 | ########### | Y | PMB | 230 | ############# | DEVELOPMENT PHASE | |||
00003344 | ABC | 25-Mar-19 | 29-Mar-19 | OSD | Amlodipine Tablets 5mg | 25-Mar-19 | Analytical Method Validation (AMV) protocol | 2 | ########### | Y | PMB | 230 | ############# | DEVELOPMENT PHASE |
Hi,
You can try adding a row number in script to make rows unique & then hide column after using as a dimension/expression/both;
data: Load RowNo() AS ROW, *; LOAD * INLINE [ Dim, Mea 1, 1 1, 1 2, 2 ];
Cheers,
Chris.
Hi,
You can try adding a row number in script to make rows unique & then hide column after using as a dimension/expression/both;
data: Load RowNo() AS ROW, *; LOAD * INLINE [ Dim, Mea 1, 1 1, 1 2, 2 ];
Cheers,
Chris.
Thanks a lot ! Chris . Never think of hiding the column too . It is a very useful tips a s well .
Have a nice day
Lim