Data Formatting - Weird columns

[sriniprad08]

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

[PhilipMannering]

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.

[sriniprad08]

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.

Thanks,

Sr

[PhilipMannering]

Hi @sriniprad08 

Does the attached work for you?

[csmith11]

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.

[sriniprad08]

Hi Team,

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,

Sr

[atcodedog05]

Hi @sriniprad08 

You can do something like this.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you very much :). I will have a look and get back to you 🙂

have a nice day,

Cheers,

Sr

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the help. Just one help not sure how to get this please. The final count below should match the number of rows in the original dataset. The input data file has 4 rows. So ideally it should be 4. 

[atcodedog05]

Hi @sriniprad08 

Something like this?

Hope this helps : )