This is my input tab that i want to move into output file but every time i tried its come out in a different format. such as when i transfer into to output file data come without $sign and also lost % sign . i want to mirror the data from input tab to output tab
Item | JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE |
1 | $ 4,578.00 | $ 458.00 | $ 1,245.00 | $ 93,124.00 | $ 4,786.00 | $ 4,589.00 |
2 | $ 22,890.00 | $ 2,290.00 | $ 6,225.00 | $ 465,620.00 | $ 23,930.00 | $ 22,945.00 |
3 | $ 45,780.00 | $ 4,580.00 | $ 12,450.00 | $ 931,240.00 | $ 47,860.00 | $ 45,890.00 |
4 | 41,202.00 | 4,122.00 | 11,205.00 | 838,116.00 | 43,074.00 | 41,301.00 |
5 | 114,450.00 | 11,450.00 | 31,125.00 | 2,328,100.00 | 119,650.00 | 114,725.00 |
6 | 91,560.00 | 9,160.00 | 24,900.00 | 1,862,480.00 | 95,720.00 | 91,780.00 |
7 | 419,161,680.00 | 4,195,280.00 | 31,000,500.00 | 173,441,587,520.00 | 458,115,920.00 | 421,178,420.00 |
8 | 4.00% | 48.00% | 81.00% | 65.00% | 20.00% | 58.00% |
9 | 419,047,230.00 | 4,183,830.00 | 30,969,375.00 | 173,439,259,420.00 | 457,996,270.00 | 421,063,695.00 |
10 | 114,450.00 | 11,450.00 | 31,125.00 | 2,328,100.00 | 119,650.00 | 114,725.00 |
What you are after is to preserve the formatting I'm guessing. You can't just read it in and output it then, as Alteryx will strip the excel formatting.
Take a look at this recent post to get ideas on just copying tabs: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Creating-a-Copy-of-Each-Tab-in...