Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Extracting data

Tid14
8 - Asteroid

Hi, I am working on a workflow where I have taken input using wildcard for multiple files (33 files).

Now from that I want to extract data contained between text summary Report and Rule summary report as attached below. But this should be extracted for all the 33 files that I have taken.

Any help on how to do that?

 

IMG_20211012_190059__01.jpg

IMG_20211012_190642__01.jpg

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Tid14 

 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

Tid14
8 - Asteroid

Sorry, all I have is this for now

Expected output is I need test summary report data for all the 33 files which I have taken as input in 1 file and that should not include the data contained under rule summary header only the test summary data is required

atcodedog05
22 - Nova
22 - Nova

Hi @Tid14 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1634046816396.png

 

Hope this helps : )

Tid14
8 - Asteroid

Thanks @atcodedog05 that was really helpful.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Tid14 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels