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.

Write value to a specific cell in excel

vijaylnyadav
8 - Asteroid

Hi,

 

I want to write a specific data to a particular cell. Can anyone suggest some workflow ?

 

Please find the below sample data and desired output

Input: - 

  ShivaRamLakhanArunArjunmore names
History 8998688552 
Science 4587789889 
Maths 7889556578 
Hindi 7889556578 
Marathi 7889556578 

 

Desired Output is used as a template.

Template: - 

 HistoryScienceMathsHindiMarathi
Shiva     
Ram     
Lakhan     
Arun     
Arjun     
Others - more names     

 

 

Expected Output: -

 

 HistoryScienceMathsHindiMarathi
Shiva8945787878
Ram9887898989
Lakhan6878555555
Arun8598656565
Arjun5289787878
Others - more names     

 

 

Condition: - 

Other names: - if any additional entries comes for instead of more names then it should replace the more names in output. 

for eg. instead of more names in output have Hari, Brahma, Krishna then in the output it should reflect as below with its desired marks.

Others - Hari     

Others - Brahma

     

Others - Krishna

     

 

Please suggest some workflow i have been trying since days.

6 REPLIES 6
L_T
8 - Asteroid

Hi @vijaylnyadav,

 

Please take a look at the attached workflow. 

 

Let me know if this works.

 

 

vijaylnyadav
8 - Asteroid

Thankyou @L_T 

but in this workflow you have not attached the output file.

 

I am not able to write the output to the same template which we are using.

 

Condition: - I want to use the template and then update the template using that in output file..

 

The attached is the output file which is to be added using the template and the data.

arjundelara
8 - Asteroid

Hi,

 

Kindly check my sample update to the WF.

 

 

 

vijaylnyadav
8 - Asteroid

Hi @arjundelara i am getting the following error while i used your technique

 

vijaylnyadav_0-1619001923201.png

 

arjundelara
8 - Asteroid

May I see the error

 

Thanks

arjundelara
8 - Asteroid

The error says it changes the field name you used the output file I sent too ?

Labels