Validation presence data, with a concatenated field

Obsyky — Wed, 01 Mar 2023 13:01:10 GMT

Hello,

Here is an example that I can have, I explain my request after :

id	name	system	system_loc	id_loc
1	name1	F	D;C;G	5;6;8
2	name2	E	R;E	3;2
3	name3	R
4	name4	G	D;C	5;6
5	name5	D	C	6
6	name6	C	F;E;R;G;D;G	1;8;3;4;5;7
7	name7	G		1
8	name8	F	F	1
9	name9	E	F	1;9

First of all, some clarifications. There is an infinity of lines, an infinity of different systems 😉

My goal is to know for each system, the number of lines that are valid or partially valid or not valid. What allows to check the validity is if there is a loc_id referenced to the system.
If I take the first line, for it to be valid, I must have at least in the column id_loc 5;6;4or7 (Why 4or7, because there must be at least one id of system G, both can be present).

How can I do this verification? My first idea would have been to break down the id_loc column into rows, then afterwards paste the system associated with the id, then check if it is in the system column. But it seems complex to me.
I'm coming to you to see if you have any simpler and potentially faster ideas.

Thank you very much

topic Validation presence data, with a concatenated field in App Development

Validation presence data, with a concatenated field