topic Re: Logic Self Join in App Development

Logic Self Join

rammuthiah — Thu, 25 May 2023 07:23:47 GMT

Hi,

I have a dataset states that ID 32 is the manuf id of z12, and ID 32 is linked with Link-ID 10,48 and 10,48 from ID is linked with 60,66 in Link-ID. So need a workaround to get all those for ManuF z12. Here the problem is ID 48 has ManuF as 100180 and 60,66 has some other ManuF.

ID	LinkID	Plant	ManuF
48		3140	100180
10		3140	500
32		3140	z12
32	10	3140	z12
32	48	3140	z12
10			100
10			500
10	60	3140	500
10	66	3140	500
66		3140	100

If I select, Plant code 3140 and manufacturing id z12, wants the below output.

PlantCode	ManufID	ID
3140	z12	32
3140	z12	10
3140	z12	48
3140	z12	60
3140	z12	66

Re: Logic Self Join

Chanty4u — Thu, 25 May 2023 06:38:22 GMT

Try this

OriginalTable:

LOAD ID, LinkID, Plant, ManuF

FROM source ;

NewTable:

LOAD Distinct

Plant AS PlantCode,

ManuF AS ManufID,

Resident

OriginalTable

Where

Plant = '3140' AND ManuF = 'z12';

Left Join (NewTable)

LOAD Distinct

Plant AS PlantCode,

ManuF AS ManufID,

Resident

OriginalTable;

NoConcatenate

FinalTable:

LOAD

PlantCode,

ManufID,

Resident

NewTable;

Drop Table OriginalTable;

Drop Table NewTable;

Re: Logic Self Join

rammuthiah — Thu, 25 May 2023 07:25:09 GMT

ID 60 and 66 has the other ManuF, So When I select the said, Its not filtering as such.