Consolidating project dates to single line

[RogerG]

Hello all,

I was trying to modify some code like this

MappingTable:
Mapping
LOAD Keyword,
	 '/' & App & '\';
LOAD * INLINE [
    Keyword, App
    xxxxxx/A 1.1, .NET
    YYYYYY, APACHE
    ZZZZZ, OFFICE
];
Table:
LOAD H,
	 TextBetween(MapSubString('MappingTable', H), '/', '\') as App;
LOAD * INLINE [
    H
    sdfsd xxxxxx/A 1.1dsfdsf
    ERWRWWQYYYYYYAEWRA
    IOPIOPIZZZZZOIPOIO
];

What I need to do is reverse the tables.

The first table will be a projects table

The second table will be a [Kickoff Meeting Date] table

The 3rd will be a [Draft 1] date

The code above will put the project date in the Kickoff table and the Draft table

but what I really want to do is put the Draft and Kickoff dates in the Project table

The only thing I have to tie these together is the Hierarchy of the project

load inline [
ID,
Outline ID, Activity, Start Date
Project/A, 1,Project,1/1/2023
Project/A, 1.1 Document, 1/3/2023
Project/A, 1.1.1 Kickoff meeting,1/5/2023
Project/A, 1.1.1.1 Draft 1, 2/1/2023
Project/A, 1.1.1.2 Draft 2, 3/1/2023
Project/B, 1,Project,5/1/2022
Project/B, 1.1 Package, 6/3/2022
Project/B, 1.1.1 Document, 6/3/2022
Project/B, 1.1.1.1 Kickoff meeting,7/5/2022
Project B, 1.1.1.2 Shell, 6/15/2022
Project/B, 1.1.1.3 Draft 1, 8/1/2023
Project/B, 1.1.1.4 Draft 2, 9/1/2023
]

These dates could run 8 layers deep, I was hoping to not have nesting of applymaps that deep

Thoughts