Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Data Formatting - Weird columns

sriniprad08
10 - Fireball

Hi Team,

 

I need help. I have a dataset which has no column names . Please find attached the input and the desired output.

 

Please let me know your thoughts,

 

Thanks,

Sr

sriniprad08_0-1639666524038.png

 

18 REPLIES 18
sriniprad08
10 - Fireball

Hi @atcodedog05 ,

 

Thank you :). i think i will come back with the clear request. Sorry 

 

Cheers,

Sri

 

sriniprad08
10 - Fireball

Hi @atcodedog05 ,

I think I have fair idea what I need. The values in the map file should look for similar values in all the columns of the data file.  If it finds more than 1 then it should be counted as 1 for that particular row.

 

thanks 

atcodedog05
21 - Polaris

Hi @sriniprad08 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

sriniprad08
10 - Fireball

Hi @atcodedog05 ,

 

Thank you for offering to help. Please find attached the file with input and expected output inside it. 

 

1) Create a new column (Site_new) - The value in the map file has to search through the input data file by each ROW and create a new column. if the value appears more than once in a row then it should be treated once.

2) Take count of the new column - In the second step it has to take the count of the new column (Site_new) by Site code and Site.

 

Thanks for the help 🙂

 

Cheers,

Sri

 

sriniprad08_0-1642210117620.png

 

atcodedog05
21 - Polaris

Hi @sriniprad08 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1642227771906.png

 

Hope this helps : )

 

sriniprad08
10 - Fireball

Hi @atcodedog05 ,

 

Thank you for the help 🙂 .Couple of clarifications from my end,

 

1) The header in this below marked in black is also a record and not the actual header. We need to create a header for all the columns.how can we go about that please? 

sriniprad08_0-1642230325365.png

 

2. This part below seems to be hardcoded. Is there way it can combine all the text. Not sure . please let me know your thoughts, 

In real data do we need to combine all the headers?

 

sriniprad08_1-1642230376788.png

 

Thank you for the help again. Please let me know if i am missing anything.

 

Cheers,

Sr

atcodedog05
21 - Polaris

Hi @sriniprad08 

 

Here is the updated workflow.

 

Workflow:

atcodedog05_0-1642230774955.png

 

Hope this helps : )

 

sriniprad08
10 - Fireball

Hi @atcodedog05 ,

 

Sorry for the delayed reply. Thank you so much for the help :). I will let you know incase of any further help.

 

Have a nice day,

 

Cheers,

Sri

atcodedog05
21 - Polaris

Happy to help : ) @sriniprad08 

Cheers and have a nice day!

Labels