Partial match : Write to new sheets

[Chandrashekarb]

Hello,

Based on below key word I need to create new sheets based on sheet name(Attached file)

1. Row no 7 condition should filter (Access and Point) and write records to sheet name(Wireless AP)

2. Row no. 7 condition should be AP(Should be equal) and Capacity(not equal to) and write to sheet name(Wireless AP)

3, Row no 1 to 6 - Key word should search in Sheet1 and write it to respective sheet name mentioned in Column B

Regards,

Chandrashekar B

[alexnajm]

Hi @Chandrashekarb,

For the sheet name part, you can create the final path via a Formula tool, and use that path in the final Output Data tool. This outlines it well:Useful Tools in Alteryx - Output Tool - Multiple Files based on field name(Contd.) - The Data School...

For the changing formula, have you checked out the Dynamic Formula as part of the CreW macros? Chaos Reigns Within: Dynamic Formula Macro

-Alex

[Chandrashekarb]

Hello,

am new to Alteryx is it possible to share workflow. 

Thanks in advance.

Regards,

Chandrashekar B

[Chandrashekarb]

Hello,

Is it possible to share work flow. I tried below workflow but it is not working for below condition.

Workflow: Here row no 7 & 8 is not working as it needs a separate condition. May I know how to incorporate it.

Regards,

Chandrashekar B

Regards,

Chandrashekar B

[Chandrashekarb]

Hello,

Any solution for it?

Regards,

Chandrashekar B

[alexnajm]

It’s probably easiest to put another Formula in the same formula tool that would calculate the sheet names for rows 7 and 8 based on your condition. The Find and Replace tool works well for matching words, but it won’t match logic unless it’s typed out the same way

[Chandrashekarb]

Hello,

Thanks for the suggestion. I will try to get the solution.

Regards,

Chandrashekar B