community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Crosstabbing a .txt file with field names in rows instead of columns

Highlighted

Hi all, I have a .txt file that I need to transform and I thought the Crosstab tool would do it but I've been having trouble with it.

 

One record is across multiple rows instead of along one row, separated by null lines. The field names are at the front, then tab and colon :, then the record value. 

 

I've been able to get somewhere by using Crosstab after I add a RecordID and then CEIL the ID divided by the total number of fields, however the result doesn't come out perfectly because the number of field rows is occasionally different across records...

 

I've added an example to show you guys what I mean exactly, hope that helps? Thanks in advance! :)

Alteryx
Alteryx

Hi @arthurmauk,

 

the workflow attached should give you what you want. I used the MultiRow formula to create the record ID.

 

Hope this helps, but let me know if I got your use case wrong!

 

Best,

Giuseppe

Alteryx Certified Partner

Hey @arthurmauk 

 

You'll need to identify the where each of the records starts first, for example using multi row formula to create a new RecordID everytime it sees "LogonName" in the field.

 

I've mocked you up a quick example.

 

Capture.PNG

 

Labels