Hello.
I have a data containing multiple columns and in some case's some of the columns may or may not be there.
Let me explain:
1. This workflow is used by many people, of which different columns may exist.
2. The problem is if a column doesn't exist, my workflow wouldn't be executed.
3. I want Alteryx to determine if the column exist and which one should be imported from the dataset.
My income data could look like this:
Type | Type code |
A | 10 |
B | 12 |
C | 11 |
A | 10 |
The problem is that the data in the [Type Code]-column, may have another name in next income dataset, like:
Type | Key code |
A | 10 |
B | 12 |
C | 11 |
A | 10 |
And a third dataset could look like this:
Type | Assembly code |
A | 10 |
B | 12 |
C | 11 |
A | 10 |
How can i determine when importing the data from an excel-workbook which of the columns contain the code?
In must case's only one of the three columns ([Type code], [Key Code] or [Assembly Code]) exist in the dataset. But there might be some case's where two of the three columns does exist, but one of them will be empty.
In addition, when Alteryx have "detected" the correct column, I would like to rename it e.g [Code]
Hope you guys can help me - thanks :)
Solved! Go to Solution.
You might look forward to input the data without headers (in your file input) and then filter to have the first line the title, this done, you may rename using . a select and use a dynamic rename.
(attached a sample workflow with 2 possible solutions depending on your case)
(hope it helped)
Any chance you can upload your import data ;) ?
I just used the first table in your post in an excel file :)
Haha, my bad :)
I understand what you are trying to do, but its not exactly what I was looking for. Maybe it's becuase I explained the problem wrongly (probably because my english ain't the best).
The case is: I will once a week get an excel-file with tons columns, sometimes it contains [Type code], [Key code] and [Assembly Code] column and other times it only contains one or two of the columns. Since the firm dont have any standard for, where to type in the values, some people write the values into [Key Code] others to [Assembly Code] and sometimes the values is typed into [Type Code].
What I know, is that only one of the three columns contain values, while the others will be empty/null.
What i want to do, is to make an Alteryx-workflow-template, which can "detect" how many of the above columns exist in the excel-file and which one is containing the values.
I was think the 'Dynamic selection'-tool with an integrated function could be a solution, but can't make it work.
The renaming part i will figure out afterwards :)
Thanks :) !
Danrh Thank you very much !