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
PhilipMannering
15 - Aurora
15 - Aurora

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.

PhilipMannering_0-1639667159500.png

 

sriniprad08
10 - Fireball

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
15 - Aurora
15 - Aurora

Hi @sriniprad08 

Does the attached work for you?

csmith11
11 - Bolide

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.

 

csmith11_0-1639675962624.png

 

sriniprad08
10 - Fireball

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
21 - Polaris

Hi @sriniprad08 

 

You can do something like this.

 

Workflow:

atcodedog05_0-1642162898223.png

 

Hope this helps : )

 

sriniprad08
10 - Fireball

Hi @atcodedog05 ,

 

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

 

have a nice day,

 

Cheers,

Sr

sriniprad08
10 - Fireball

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. 

sriniprad08_0-1642170604222.png

 

atcodedog05
21 - Polaris

Hi @sriniprad08 

 

Something like this?

 

atcodedog05_1-1642171007844.png

 

Hope this helps : )

 

 

Labels