Help Data prep.

Hi All,

I used the new Text Mining tool, and I could extract some info out of a PDF invoice. Unfortunately, it gives me all the results in a row, but I need a second row for items. I named them Row1 and Row2. Would you please guide me on how I can sort them? I am very new to Alteryx.

Thank you in advance,

30-08-2020 1-09-09 AM.jpg

Regex

Preparation

Text Mining

Accepted answers

vizAlter

@VahidGoli — If posted replies solve your issue please mark the answer as "Solved" with a Like, if not let me know!

This will help other users find the same answer/resolution. Thank you.

Additional — You may refer to the attached workflow if you are really concerned about the trick solutions. 🙂

Arrange from Columns to Rows_v2 (on actual data).yxmd

Arrange from Columns to Rows_v2 (on actual data).yxzp

All comments

vizAlter

Hi @VahidGoli — You can do it as well.

Can you please attached your data or export this result using "Output" tool so that we could assist you?

VahidGoli

Hi @vizAlter,

Thanks for your response. Sorry for my silly question, but I am very new to this community and software. Would you please let me know what do you mean by "Output" tool? Do you need my workflow or..?

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703