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

Data Validation

vijaylnyadav
8 - Asteroid

Consider the following data,

 

Roll NumberPerformance
1Good
2Average
3Bad
4Average
5Good
6Good
7Bad
8Bad
9Average
10Average

 

Condition:

I want to group the data according to the performance

e.g.: All the good in one, bad in one and Average in one like the below result which i wanted

 

PerformanceRoll No
Good

1

5

6

Average

2

4

9

10

Bad

3

7

8

 

 

Please suggest some workflow.

Thanks 

 

 

12 REPLIES 12
Emil_Kos
17 - Castor
17 - Castor

Hi @vijaylnyadav,

 

Do you need to have them in a merged cell? 

vijaylnyadav
8 - Asteroid

@Emil_Kos  Yes I want to have in a merged cells

 

Emil_Kos
17 - Castor
17 - Castor

Hi @vijaylnyadav,

 

I am not sure if this is possible. At least I wasn't able to find an answer in the community.

 

At the same time, this topic states you cannot do that for the XLSX format. 

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Conditional-Merging-of-cells/td-p/3901...

 

Apologies that I couldn't help you more. 

vijaylnyadav
8 - Asteroid

@Emil_Kos can you help me on the below problem:

 

I have a multiple output data(more than 10) and I want to save all the data in a single excel file.

I am using folder browse so that the user can select their desire output after that I am using action tool that will update the output with formula but i am facing an error and i.e. sometimes it is saying that access denied and sometimes it is saying that file is being used by different process.

Therefore I have used block until done but still I am facing the same error and I am unable to save my output to multiple tabs in single excel files.


Some solutions will be a great help.

 

i have attached a sample data and sample workflow for your reference.

 

I am stuck at this point so please help me out.

Emil_Kos
17 - Castor
17 - Castor

Hi @vijaylnyadav,

 

You forgot to add attachments.


Please create a new topic as it will make whole process easier. 

Qiu
20 - Arcturus
20 - Arcturus

@vijaylnyadav 
Tried with embeding new line in the formula.

0104-vijaylnyadav.PNG

vijaylnyadav
8 - Asteroid

Thanks @Qiu  for your help but till text to column tool all is fine but after that the data are missing means for only one type we are getting only one data and other data are lost

Qiu
20 - Arcturus
20 - Arcturus

@vijaylnyadav 
The data is not lost. 

One step is required though, which is to increase the row height in opened output Excel file.

Qiu_0-1609759259236.png

 

vijaylnyadav
8 - Asteroid

thanks @Qiu  for this effort I got the desired output.

 

Pleae help me on another post of Mulitple Tabs.

Labels