I am new to the forums so thank you in advance for your help. I am looking to use an input step for a CSV file that will unzip a .zip file (not .gz or gzip). I suspected this would be easy to do, but I am stuck.
I have attempted to used the "GZIP CSV Input" step. But it can't handle .zip files. I have also read that "CSV file input" would work on .zip files. But that hasn't been my experience, that doesn't work either.
Lastly, it appears that there used to be an "unzip file" transformation. But unless I am going nuts, that transform no longer exists in pentaho 8.
So with that back ground. Can I either:
A) Input a .zip csv file?
B) do a transform that will unzip the file for me?
Thanks again in advance