unzip .zip file in data loading activity

[sharma_nik]

Hi

I want to unzip a zipped file in data loading activity.

I checked pre-process the file option and tried various commands but the data load activity is giving error every time.

Following are the commands I have tried:

gunzip -c <%=vars.filename%>

gunzip <%=vars.filename%>

gzip -d <%=vars.filename%>

gzip -S <%=vars.filename%>

zip -d <%=vars.filename%>

etc.

What would be the correct command to unzip the file first and then load it?

[sharma_nik · Accepted solution]

Hi

If it helps someone, I found the solution.

You can use the following command.

zcat <%=vars.filename%>

Thanks