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.
SOLVED

Generate input templates dynamically

chinu267
8 - Asteroid

Good Day Everyone.

 

Need your expert guidance to be able to create a dynamic template that users will be filling information with.

 

In file "Inputs.xlsx" the "Input-1" sheet is what will go into every file based on "data filed" and "file name" from sheet "Input-2". This should create me 7 new files with file name as in "Unique File Name". Every column in "Data Field" needs to be appended as a column header to "Input-1".

 

The New headings for each file is as below:

 

DOTY-Dealer Standards CI.xlsx

 

IDCealerCDDealerNameTownRegionDistCategoryDealer Standards CI
11111CitrusdalCitrusdal132E 
20022KrugersdorpKrugersdorp112B 
31122Louis TrichardtLouis Trichardt132D 
41124MalmesburyMalmesbury132E 
51119 ModimolleModimolle132E 
61118 MokopaneMokopane132D 
79111MoorreesburgMoorreesburg132E 
89110North WestLichtenburg132D 
99110North WestZeerust132D 
109004RoodepoortRoodepoort112B 

 

 

Overall Recognition-Best in CVP Sales.xlsx

IDCealerCDDealerNameTownRegionDistCategoryBest in CVP Sales 
11111CitrusdalCitrusdal132E 
20022KrugersdorpKrugersdorp112B 
31122Louis TrichardtLouis Trichardt132D 
41124MalmesburyMalmesbury132E 
51119 ModimolleModimolle132E 
61118 MokopaneMokopane132D 
79111MoorreesburgMoorreesburg132E 
89110North WestLichtenburg132D 
99110North WestZeerust132D 
109004RoodepoortRoodepoort112B 

 

Overall Recognition-Best in CVP Service.xlsx

IDCealerCDDealerNameTownRegionDistCategoryBest in CVP Service
11111CitrusdalCitrusdal132E 
20022KrugersdorpKrugersdorp112B 
31122Louis TrichardtLouis Trichardt132D 
41124MalmesburyMalmesbury132E 
51119 ModimolleModimolle132E 
61118 MokopaneMokopane132D 
79111MoorreesburgMoorreesburg132E 
89110North WestLichtenburg132D 
99110North WestZeerust132D 
109004RoodepoortRoodepoort112B 

 

and so on so forth....

 

refer to the inputs for details.

 

Thanks & Regards,

 

Chinmaya.

8 REPLIES 8
afv2688
16 - Nebula
16 - Nebula

Hello @chinu267 ,

 

Hope this does the trick!

 

Untitled2.png

 

It takes the sheet name after the dash and applies it as a new column.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Regards

chinu267
8 - Asteroid

You did not take into account input-2 that will be used as a column....

afv2688
16 - Nebula
16 - Nebula

It was only a demnostration of how to do it.

 

Here is the full workflow with which edits every sheet in the file

 

Regards

chinu267
8 - Asteroid

Thanks again for your efforts..let me re explain the requirements

 

If you look at my expected output, I need to add an extra column for each data field onto sheet "input-1" and that file has to be saved as the unique file name for every individual instance. 

afv2688
16 - Nebula
16 - Nebula

I think now I got what you wanted.

 

Sorry for the misunderstanding.

 

Untitled.png

 

Regards

chinu267
8 - Asteroid

Regret, the columns from sheet below needs to be added to the data in input-1 and for every row under data field has to be written to a new file. Say if data field is "Academy", it needs to be added as a column to sheet "Input-1" as

 

"

IDCealerCDDealerNameTownRegionDistCategoryAcademy

"

 

and that needs to be saved as excel "Sales Merit-Academy.xlsx"

 

Data Field
% use of CoOp funds
Academy
Academy TNA completed
Best in CVP Sales
Best in CVP Service
Dealer Standards ALL
Dealer Standards CI

 

Sorry for the trouble. Sent you a msg with my number

chinu267
8 - Asteroid

Please ignore the previous message. It works. Now I can connect to the DB and process all 140 odd files I believe. This was a sample of 10 records. DB has much more.

 

Really appreciate your help.

 

 

afv2688
16 - Nebula
16 - Nebula

Glad it helped 🙂

 

Have a nice weekend! 😄

Labels