Lets consider the snippet above. The requirement is that the attributes in bold must be imported on to alteryx with their corresponding values next to them on to alteryx so that they can be compared to the same columns from another file.
I am having trouble in importing these values or aligning them in some way so that i can compare with the other file.
is there any way to achieve the below?
Solved! Go to Solution.
Are the input files always in the same format ?
Where 3rd and 4th row have the info to be transformed.
Hi, Can you pls provide the sample files to work on this
hi @hegdepavithra10
This is definitely achievable, as @atcodedog05 said however, I am curious as to whether these are always in the same position. Can you please upload the excel spreadsheet that you screenshot above, and i'll be more than happy to take a look at this for you!
Cheers,
Owen
Yes. They are always in the same format.
Here are the files. The snippet i attached is from the file named as "Alteryx sample(i). So this is the use case. There are multiple Alteryx sample files. They are based on the type value in file "Alteryx main file".
(i)I need to compare the numerical values under the bold attributes in both the files.
(ii)The bold attribute names in both the files are not exactly same.
That's great info. Can you provide some sample files and expected output. So that we can stream line our workflow according to the requirement.
Edit : great you just shared 🙂
Thanks
The sample files will be in the same format, they wont change.Just the numerical values will change. So a generic workflow for the files i have provided would suffice for the rest.
hi @hegdepavithra10
I have achieved a workflow that received the output you were hoping for:
I'm sure @atcodedog05 knows a way of making it much more concise and elegant, but this works with your excel sheet provided!
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 and what you are looking for.
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍