Suppose, I have a retail data in which I have a product category column and I want to save different categories in different CSV files. How can I do it?
To partition the data in product category column, the following steps need to be followed:
- Load the data using a Read processor.
- Use another Read CSV processor and select the required settings. Then, go to the - Advanced tab and select the column on which you want to perform partitioning. Press Ok.
- Now, execute this workflow. This will create a separate CSV file for each category and all the files will be saved to the location specified by you.
Hello Lily, please find the solution below.
To partition the data in product category column, the following steps need to be followed:
- Load the data using a Read processor.
- Use another Read CSV processor and select the required settings. Then, go to the - Advanced tab and select the column on which you want to perform partitioning. Press Ok.
- Now, execute this workflow. This will create a separate CSV file for each category and all the files will be saved to the location specified by you.