Reading files after python code

Hello Experts,

I have a requirement in which I am using python code to unzip files now I want to read files which got unzipped, so I want to run the python code first and then the files get loaded through input tool to perform transformation.

Thanks in advance

Ferha Shrama

Python

Preparation

Accepted answers

All comments

atcodedog05

Hi @ferha_jafri

Approach 1: you can write the code to read excel file in python code only that way flow is ensured.

Approach 2: You can pass the file path from python tool to dynamic input tool and read. Since the dynamic input tool requires the path it will wait for python code to complete.

Hope this helps : )

binu_acs

@ferha_jafri the Input Tool has the ability to read the zip files, may be you can try in that way also

apathetichell

return a data.frame of unzipped file paths (are these all files of the same type?) from the python tool.

feed in the file locations to a batch macro with the proper input tool and configs.

atcodedog05

Adding to above

or use a for loop in python change the file path to read them all and union them.

Hope this helps : )

ferha_jafri

The problem in this solution which I am facing is every time the file name is changing so how to solve this for dynamic file names.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703