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
Hi @sriniprad08
Here is the updated workflow.
Workflow:
Hope this helps : )
Here is how you can do it.Workflow:
Please find the updated workflow
What do you need help with?
I think you just need to tick First Row Contains Data in the configuration pane of the Input Data Tool.
Hi @PhilipMannering ,
Thank you for the help. Sorry if i was not clear.
1) I need the data in separate columns. (As you have already shown) but the in your pic the data is repeated in 9th and 17th row. I need data only till row 7.
2) I need to split the column "F4" separately. Anything after the "=" in separate column. For eg. in Manganese will be in separate column.
The pic i pasted describes the different "Output" i am looking help for.
Does the attached work for you?
Did you need all 3 outputs mocked up?
There is some confusion regarding field names I noticed Field X7 was repeated. So Changed it to X8. For output B I Change the last column X8 to be X9 instead.
Hope you are well . I need further help on this. Currently i have one file with all the data and the other file called mapping file.
Requirement : The alteryx work flow should search or look for all the values in the mapping file with the data file and get the count. Please find below the input file and the mapping file and the desired output.
Input file: Question_1
Mapping file : map_1
Desired output : Output_1
The challenge is that the mapping values to look up are present in different columns of the data file. It has to search and map.
Thanks for the help.
Cheers,
You can do something like this.
Hi @atcodedog05 ,
Thank you very much . I will have a look and get back to you 🙂
have a nice day,
Thank you . i think i will come back with the clear request. Sorry
Sri
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
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 🙂
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?
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?
Thank you for the help again. Please let me know if i am missing anything.
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,
Happy to help : ) @sriniprad08 Cheers and have a nice day!
Hope you are well. I need help. In the flow you provided , i would like to create a column based on the "Site_new". if there are multiple values in the row then a new column should be created "indicator".
Formula will be - if count of (Site_new) is > 1 then 1 or 0.
In the below case we can see marked in "Red" has two values . So the output should be 1 in the "new column" created.
Please let me know how to go about this,
Thanks
Thank you so much for the help
Thank you again
Cheers
