Not sure how to solve it. Issue with three tables.

[#1]

Hi i'll try to explain this. For sure i've have still a lot to learn, but did my best and didn't got the solution. I've attached all the files of the example i've made.

there are 3 files:

INCICENTS

CHANGES

TASKS

Each ID have associated a SERVICE DESCRIPTION. But SOME TASKS don't. All TASKS have a asocciated CHANGE, and all the changes always have a SERVICE DESCRIPTION.

I'm trying to associate the TASK service description with the service description of it's change.

ID	SERVICE DESCRIPTION	TYPE	LOCATION
CH001	THIS IS A DESCRIPTION TEST1	CHANGE	NY
CH002	THIS IS A DESCRIPTION TEST2	CHANGE	EU
CH003	THIS IS A DESCRIPTION TEST1	CHANGE	NY
CH004	THIS IS A DESCRIPTION TEST2	CHANGE	EU
CH005	THIS IS A DESCRIPTION TEST1	CHANGE	NY
CH006	THIS IS A DESCRIPTION TEST2	CHANGE	EU
INC001	THIS IS A DESCRIPTION TEST1	INCIDENT	NY
INC002	THIS IS A DESCRIPTION TEST1	INCIDENT	NY
INC003	THIS IS A DESCRIPTION TEST2	INCIDENT	EU
INC004	THIS IS A DESCRIPTION TEST2	INCIDENT	EU
INC005	THIS IS A DESCRIPTION TEST1	INCIDENT	NY
T001		TASK
T002		TASK
T003	THIS IS A DESCRIPTION TEST1	TASK	NY
T004	THIS IS A DESCRIPTION TEST2	TASK	EU
T005		TASK
T006		TASK

I cant get the service description and the location of the task from it's related change. can any one help pls??

I've tryied a lot of things, but none was successfull

huge thanks in advance.

[Anonymous]

I solved this specific problem for you using the "Mapping LOAD" and ApplyMap-function. I commented in the script to try to explain what I did. Hope this helps!

Read more: Don't join - use Applymap instead

See attached file.

[#3]

Thanks for the fast answer! Kim, the file is without comments :/, maybe wrong upload?

there is nothing but this.

LOAD * Inline

[Rep_Name, amount

1,1000

2,3000

3,2000

];

Can't see any other thing on it!

Could u check it again pls? thx!!

[ElizaF]

Hello,

My opinion is that the structure of database is not well defined and also how are the links between tables.

You can use Link table (see below) or the example for attached file.

what is use of link tables ,how to use it

I do not know if it is what you want.

[#5]

First of all thanks for the answer, but also in your exemple:

a: changes are not listed

b. Incidents dont fill up alias neither location, based on the information on the SERVICE DESCRIPTION.

(seems it's more tricky than i thought) 😕

thanks for the help!

[ElizaF]

I do not understand what are your requirements.

Can you post the desired result?

[Anonymous]

Oh, sorry! I was too quick I guess.. Take a look at the attached file.