I'm stuck in my coding...
I created file upload and get the value from the uploaded file (excel) then I wanna split into multiples file based on uploaded file.. How to do that?
I just created file that successfully created multiples file but the value in its file creating that I don't want to...
This is example file I upload (.xlxs)
store_number | order_number | business_date | item_number | description
123 | 123.1 | 2019-02-01 | AA1 | tea
123 | 123.2 | 2019-02-01 | AA1 | tea
124 | 124.1 | 2019-02-01 | AA3 | coffee
124 | 124.1 | 2019-02-02 | AA2 | juice
So, based on the excel file, when I uploaded this.. I wanna split into 3 file based on store_number and business_date
123_2019-02-01
124_2019-02-01
124_2019-02-02
How to do that? Thanks