Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Query on Practise Exercise 4

JB001
6 - Meteoroid

Hi, please see attached workflow. I am attempting to complete the final step and am using an IF formula - but the final output has all the product category and shipping method instances listed out instead of just one. How do I get it just to list one of each instance?

5 REPLIES 5
Raj
16 - Nebula

@JB001 
all the input files are missing
you need to add the zipped workflow.

JB001
6 - Meteoroid

Apologies, let me know if this works

 

 

Raj
16 - Nebula

@JB001 
go to designer >- options >- export workflow>

best way to zip all the inputs into workflow while sharing with others.
hope this helps to share the workflow

extension -.yxzp

JB001
6 - Meteoroid

@Raj Thank you, I think this should work now. 

 

I think I have managed to sort my initial query. There is another problem with the final formula, it is saying that "the field ... is not contained in the record" (the field I'm searching for is "technology") - but it is present in the record? Would appreciate any guidance.

Raj
16 - Nebula

@JB001 
find the sol attached.

 

Labels
Top Solution Authors