Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Parsing The Data

shashank_shukla
8 - Asteroid

Hello,

 

Scenario:-  I am fetching one column from database which contains the Comments and from the comments I have to only fetch the specifics words and order of the words is not fixed only base of some keywords I have to fetch the data.

 

Ex:- 

InputOutput1output2
I am working on [Issue:0] and the result is [Invalidreason:Not submitted]0Not submitted
I am working on [Issue:1] and the result is [Invalidreason:Resolved]1Resolved
I am working on [Invalidreason:Transfer]  and the result is [Issue:3]3Transfer

 

The example is mention the same way I am getting the data. The order of [Issue:...] and [invalidreason:......] is not fixed.

Can anyone help me to find out the solution.

If possible kindly attach the sample solution as well.

 

Thanks And Regards,

SHASHANK R. SHUKLA

 

11 REPLIES 11
shashank_shukla
8 - Asteroid

Thanks @OllieClarke ,

 

For your quick response its means a lot.

Your solution is working fine for me.

 

OllieClarke
15 - Aurora
15 - Aurora

@shashank_shukla Great to hear :)

Labels