unzip .zip file in data loading activity

Question

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 Answer

Hi If it helps someone, I found the solution. You can use the following command.zcat <%=vars.filename%>  Thanks

Sign up