What components should I use?

Question

I'm new to Alteryx,

I have to create two new components to the existing workflow (screenshot), I have to load some Excel Files into it. What I have to do is load (A) files set with the (A) flag and (B) files with the (B) flag. The flags are columns in the table where it'll be uploaded.

Thanks

Screenshot (331).png

binu_acs · Answer

@llciii Connect the table tool after the formula tool which creates the flag

Sample_170323.yxmd

llciii · Answer

Ok thanks @binu_acs the two excel files (screenshots) already exist and the table data will be populated once the workflow has been ran successfully. Now I have a new column that'll be created in the table, which is "Flag"

Let's say that Screenshot 332 is A files and screenshot 333 is B files.

Screenshot (332).png

Screenshot (333).png

binu_acs · Answer

@llciii Based on my understanding I think you need to create two excel files based on a variable called flag if the flag=A then write to one excel if B then writes into another excel. If that is the case use the formula tool and create a flag and update the path. Attaching a sample workflow for your reference

Sample_170323.yxmd