unzip .zip file in data loading activity

Avatar

Avatar
Affirm 1
Level 1
sharma_nik
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Boost 1
View profile

Avatar
Affirm 1
Level 1
sharma_nik
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Boost 1
View profile
sharma_nik
Level 1

13-07-2021

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 1
Level 1
sharma_nik
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Boost 1
View profile

Avatar
Affirm 1
Level 1
sharma_nik
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Boost 1
View profile
sharma_nik
Level 1

13-07-2021

Hi

 

If it helps someone, I found the solution.

 

You can use the following command.

zcat <%=vars.filename%>

 

 

Thanks

Answers (0)