have 20 files to input in my Alteryx. Their file names follow a pattern
FileNames
A2A_S10_050
A2A_S43_070
A2A_S70 010
A2A_S20 03
etc
When the workflow is run, i need to add 2 fields Field A and Field B based on these names such s
File Names Field A Field B
A2A_S10_050 10 50
A2A_S43_070 43 70
A2A_S70 010 70 10
A2A_S20 030 20 30
A2A_S55 55 10 (If only first number is present then Field B is defaulted to 10)
A2A_S40-010 40 10
A2A_PART1_S40-010 40 10
A2A6_S85 85 10
Regards
Abhijeet