Adding 12 months on top of each table?

[Carluccio555]

I have 2 sets of 55 tables multi-joined by record, I have the tables set to not show column headings which are as follows:

I have entered the above as a singl e row in a text input tool

:What is the best approach to add this as a heading to all of my 55 tables which are joined, Ive also added a layout after the join.  Just need to get these darn month headings on top.

thanks

[KrishnaChithrathil]

@Carluccio555 

you need to add the above given as a header to another table?

[DenisZ]

You could union them together, make sure to attach this text field first, then the other data. Then use the dynamic rename and choose "Take field names from first row of data" 

Hope this helps

[Carluccio555]

I dont think union will work because im using layouts. FOr some reason my month headings don't appear in the output

There are 2 layouts with 55 records each, I use the multijoin and they sit on top of each other how i want.

I have the Text Input tool month headings and also attach to a layout tool, but it doesnt appear in the output. I think I need to create 55 headings and join by record maybe?

I like the flexibility of the headings being separate so I can rearrange tables how I need and then put the months on top. WHat is the best way?

[Carluccio555]

Thought this would be simple but it's telling me I found a bug when I try to join 55 headings on top of my tables!

The grey circled layouts are linked to a table tool each with 55 table records, I join them with the multijoin and remove table headings.

Now the red circled layout is linked to a text input tool with 55 records of 'Jan, Feb, Mar et etc'.

The bug has occured when I try to multi-join by record the month headings to the other joined layouts

[Carluccio555 · Accepted solution]

Here is the solution I came up with:

Basically I had to make the headings in a table with the same number of records as my layouts, then use a mutijoin by record