Forum Discussion
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
- AnonymousNot 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 - AnonymousNot 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