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
