Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have two tables, post some transformations concatenated two tables into one.
my data looks like below - count wise giving correct value, but when I add all the fields to table giving extra records because we did concatenate two tables.
How do I restrict duplicate data ?
ID | TransID | Type | StartDate | EndDate |
900 | N/A | |||
Sunil | 100 | Normal Shift | 01/01/2023 | 12/31/2099 |
100 | ||||
Ramesh | 110 | Normal Shift | 01/01/2023 | 12/31/2099 |
110 | ||||
Prasad | 111 | Normal Shift | 02/09/2023 | 02/05/2024 |
111 | ||||
Ramana | 115 | Night Shift | 01/02/2023 | 12/31/2099 |
115 | ||||
119 | N/A | |||
Jai | 120 | Night Shift | 01/01/2023 | 12/31/2099 |
120 |
my output should be below..
Name | EmployeeID | Type | StartDate | EndDate |
900 | N/A | |||
Sunil | 100 | Normal Shift | 01/01/2023 | 12/31/2099 |
Ramesh | 110 | Normal Shift | 01/01/2023 | 12/31/2099 |
Prasad | 111 | Normal Shift | 02/09/2023 | 02/05/2024 |
Ramana | 115 | Night Shift | 01/02/2023 | 12/31/2099 |
119 | N/A | |||
Jai | 120 | Night Shift | 01/01/2023 | 12/31/2099 |
Thanks in Advance!
Hi you can try this
ConcatenatedTable:
LOAD DISTINCT
ID,
TransID,
Type,
StartDate,
EndDate
RESIDENT Table1;
ConcatenatedTable:
LOAD DISTINCT
ID,
TransID,
Type,
StartDate,
EndDate
RESIDENT Table2;
these tables are not straight - we have many calculations in between.
can we handle in UI?
@tresesco, can we handle in UI ?
Experts, need suggestion please
Use straight table; dimension TransID, and for other columns use Maxstring(... and Date(Max(... for date columns, like: