Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Extract Data without changing the format

Piyalipiu27
6 - Meteoroid

Suppose I have two input sheets and I have to update one of them extracting the data from the other, how can I do it.

I did it with join and all but the format got changed

6 REPLIES 6
messi007
14 - Magnetar

@Piyalipiu27,

 

Could you share a sample data with what you expect to have?

It will help to give you the solution.

 

Regards

Piyalipiu27
6 - Meteoroid

So Book1 has Jan, Feb and Mar data

and I want Book2's vale to be extacted to Book1 as a new sheet named as Apr but in the same format

 

messi007
14 - Magnetar

@Piyalipiu27,

 

You can do this using Python,

Attached the workflow, you have to update the paths and run Alteryx designer as admin in order to install openpyxl package.

 

Hope this helps,

Regards

Piyalipiu27
6 - Meteoroid

We dont have python, need to do it from alteryx itself

messi007
14 - Magnetar

@Piyalipiu27,

 

I don't think that you can do this natively with Alteryx.

You can do it with VBA or Python.

I add @atcodedog05  to confirm or not 🙂

 

Regards

atcodedog05
22 - Nova
22 - Nova

Hi @Piyalipiu27 

 

That's correct as @messi007 said sadly this is not natively possible in Alteryx 😅

 

This requirement is more on the process automation side than on the ETL side.

Labels