topic Re: concatenate giving wrong result in App Development

concatenate giving wrong result

paulwalker — Mon, 08 May 2023 17:26:31 GMT

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!

Re: concatenate giving wrong result

Chanty4u — Mon, 08 May 2023 18:08:36 GMT

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;

Re: concatenate giving wrong result

paulwalker — Mon, 08 May 2023 18:41:28 GMT

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

can we handle in UI?

Re: concatenate giving wrong result

paulwalker — Tue, 09 May 2023 02:37:48 GMT

@tresB, can we handle in UI ?

Experts, need suggestion please

Re: concatenate giving wrong result

tresB — Tue, 09 May 2023 05:53:27 GMT

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