Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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
15 - Aurora
15 - Aurora

@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
15 - Aurora
15 - Aurora

@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
15 - Aurora
15 - Aurora

@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