We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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