Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Union similar sheets of different workbooks

RajatRehria
アステロイド

Dear Community,

 

I hope you all doing well. Kindly help me solving a query.

 

I have two Different workbooks (Sample_1 and Sample_2) with multiple sheets in each workbook, however I want a sheet (named "One") which is available in both the workbooks and are very similar but i am not finding a way to bring both workbooks via Directory tool and Union those similar sheets (i.e. "One") which I want to combine.

 

I have prepared two macros for the same however one of macro which Union both the similar sheets is not working, Kindly help. Many thanks.

4件の返信4
binuacs
ポラリス

@RajatRehria You need to update your macro. Attaching the sample workflow 

 

binuacs_0-1669654455425.png

 

RajatRehria
アステロイド

Hi Binuacs, can u please share this workflow in Alteryx Version: 2020.4.5.12471 as while opening i am getting an error (refer attached) and it not opening.

 

binuacs
ポラリス

@RajatRehria attaching the workflow and the macros

 

RajatRehria
アステロイド

Many thanks for the solution

ラベル
トップのソリューション投稿者