Second Opinion

[Sherif_Elkholy]

Hi,

Can someone please check my work flow and advise if it can be optimized?

data set is attached as .xlsx file.

[yalmar_m · Accepted solution]

Hi @Sherif_Elkholy,

I think this might be better, a datacleanse instead of both formula tools and both dynamic renames combined in one tool.

Best,

Yalmar

[neilgallen]

@Sherif_Elkholy "Optimized" is a bit relative here, depending on if you mean "fewer tools" or "runs faster"

This entire process can be accomplished in one Regular Expression tool, but it doesn't execute any faster on the sample dataset that you provided. It just takes less steps.

[Sherif_Elkholy]

Thanks @neilgallen. The columns Visa_in_flow and Visa_out_flow have null values.

[neilgallen]

@Sherif_Elkholy  perhaps you did not input the regular expression correctly? see attached worfklow.