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

Make new rows with input from field in other row

Vmgh
6 - Meteoroid

Hi all, 

 

IDDateID2
CPM_422.pptx2019-09-09 10:35CPM_422
CPM_185_410_433_one-pager.pptx2019-01-14 14:40CPM_185
CPM_323 one-pager.pptx2018-11-23 11:15CPM_323


In my column "ID2" i have the desired format that i can use to join two data sets with. Found by RegEx. my problem is that  some of my original "ID" cells contains merged names so to say "CPM_185_410_433_one-pager.pptx". I would like to create new columns so that each ID got it's own column with the same date as for the merged one (see below). is that possible? 

 

CPM_185       2019-01-14 14:40

CPM_410       2019-01-14 14:40 

CPM_433       2019-01-14 14:40



/Vmgh

4 REPLIES 4
Martyn
9 - Comet

@Vmgh 

 

Try using a RegEx tool with the following settings

 

Martyn_0-1572015028474.png

hlmess
7 - Meteor

You can try a modified Regex Expression to tokenize your ID to recognize multiple IDs.

hlmess_0-1572015108394.png

Resulting in:

hlmess_1-1572015119350.png


From there, you can Append the CPM to all of your Parsed IDs. Note that this will only work if the IDs are the only sets of digits following an underscore in the file name. 

Vmgh
6 - Meteoroid

Thank you very much for the answer! 

Vmgh
6 - Meteoroid

Thank you very much for the answer!

Labels