Hi All,
I am trying to make YTD excel file. I have Cust ID (unique ID) and monthly cash. No issues in running first month. I am not sure how should it be programmed to put next month in next/new column. So to run 2nd month, I am trying to achieve below
1. Match the cust ID (with new month data), if same then make new column to show the monthly cash
2. If not same, then add the Cust ID at the bottom of file (1st month will be 0) and 2nd month will have value (for example Cust ID C, and M2 has 9000).
Cust ID | M1 | M2 | M3 |
A | 8000 | 86 | 450 |
B | 60 | 4500 | 0 |
C | 0 | 9000 | 260 |
D | 0 | 0 | 46 |
Hope my question above make sense.. If not, I will try to explain further
Solved! Go to Solution.
Since there's some logic needed to determine when & where to write different pieces of data, I wouldn't try to approach this as "appending to an existing Excel sheet".
Instead, I'd suggest loading in the current Excel sheet as another Input, then Joining that dataset with your new month's data to get the wholistic dataset. Then, it's just a simple Overwrite Sheet in the Output Data tool.
Thank you MattBSlalom, I actually tried the other way and it worked. Thank you:)