concatenate giving wrong result

[paulwalker]

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!

[Chanty4u]

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;

[paulwalker]

these tables are not straight - we have many calculations in between.

can we handle in UI?

[paulwalker]

@tresesco, can we handle in UI ?

Experts, need suggestion please 

[tresesco]

Use straight table; dimension TransID, and for other columns use Maxstring(... and Date(Max(... for date columns, like: