Hi Community,
I am working with a large data set, when I combine the data it separates it into three csv workbooks and two tables in MS Access. To do proper analysis, I need all this data is one place. Why is it grouping data into different sheets? Is it due to the amount of data? I did not think csv or Access had true limits?
As a possible fit, I wanted to create new columns based on date. For example, if all the other columns were the same type and product have one column for April, May and June Balances without summing them.The data currently looks like this:
Type | Product | Balance | Month |
Type 1 | Product 1 | 3 | June |
Type 1 | Product 2 | 12 | April |
Type 2 | Product 2 | 8 | May |
Type 1 | Product 1 | 10 | May |
Type 2 | Product 2 | 44 | April |
Type 2 | Product 1 | 20 | May |
But I want it to look like this if all other columns are equal (I have about 50 columns):
Type | Product | April Balance | May Balance | June Balance |
Type 1 | Product 1 |
| 10 | 3 |
Type 1 | Product 2 | 12 |
|
|
Type 2 | Product 1 |
| 20 |
|
Type 2 | Product 2 | 44 | 8 |
|
Would something like that reduce the rows?
Solved! Go to Solution.
Is there a way to get my data to go into 1 csv file? I do not understand why it is breaking it up into three files when csv does not have a data limit?
All of your data should go into one file.
Do you have either of these options filled out? Are you able to post your workflow and dataset?
Hi @erricos , check if you have tick checked the Take File/Table Name from Field uncheck it or use the configuration mentioned in screenshot below. I hope it helps.
Thanks.
I had the Take File/Table Name from Field checked by accident! Thank you for your help.