Consolidating project dates to single line

RogerG — Wed, 23 Nov 2022 14:10:21 GMT

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

topic Consolidating project dates to single line in App Development

Consolidating project dates to single line