Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Getting values from column data

TarunDeep
8 - Asteroid

Hi,

 

I am getting below line as a value in one of the columns from my input. I want to extract specific information from this value as below. 

 

Value:

 

com.xyz.xx.service.run.Run@511de277[id=11293,rvi=49989,state=ACTIVE,name=OUTSIDE XX2W 19.11,startDate=2019-05-22T09:29:55.687-04:00,endDate=2019-06-05T09:29:00.000-04:00,completeDate=<null>,sequence=11293]

 

 

I want below output values in seperate columns as:

 

id=11293

rvi=49989

state=ACTIVE

name=OUTSIDE XX2W 19.11

startDate=2019-05-22T09:29:55.687-04:00

endDate=2019-06-05T09:29:00.000-04:00

completeDate=<null>

 

Is it possible?

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @TarunDeep 

 

Here's a solution:

 

COlumndata.PNG

 

- Use Regex to isolate what is in brackets - REGEX_Replace([Field1], "^.*\[(.*?)\]$", "$1")

- Text To columns to split to rows comma separated values

- Split again with text to columns - to columns (using "=" delimiter)

- Cross-Tab using the values on the left of the equal sign as columns

 

WF attached.

 

Cheers,

 

TarunDeep
8 - Asteroid

Thank you @Thableaus That is what I wanted. It was quick. 

Thableaus
17 - Castor
17 - Castor

@TarunDeep 

 

You're welcome, my friend.

 

Just another tip:

 

If you have many strings like these in rows, you can use a Record ID to properly order the results:

 

recordID1.PNGrecordtip.PNG

 

- Add the Record ID and then group by in your Cross Tab Tool.

 

Cheers,

Labels
Top Solution Authors