Forum Discussion

tferenc80's avatar
tferenc80
New Member
5 years ago

Taking over column from a table into another table dynamically

Hello All! I have a problem that I cannot solve.

 

So I have table 1 with columns of which headers are calendar week numbers. So 41, 42, 43, etc. This comes from a sharepoint xsl file and will have further columns as the time goes.

 

Now I have another table where I want to have the same data but with a defined delay, which can be changed. So I say that the delay is now =2, and then column 42 from table 1 should appear in table 2 as column 44.

 

Can anyone recommend a solution for this?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi tferenc80 ,

     

    Your requirement may not reach currently... All I could do is select columns and rename them like this:

    Table =
    SELECTCOLUMNS ( 'Table1', "44", [42], "45", [43] )

    Did I answer your question ? Please mark my reply as solution. Thank you very much.

    Best Regards,
    Eyelyn Qin

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi tferenc80 ,

     

    Sorry to disturb you...

    But did I answer your question ? Please mark my reply as solution. Thank you very much.


    Best Regards,
    Eyelyn Qin