I’m a new user and I created 15 “Regex” rules when using the Replace function.
I saved the choices, however when I bring in a new Dataset it will not accept/import the data.
I’ve tried bringing in the data set and highlighting the dataset and it is not saving.
Does anyone have a suggestion how I can input this new file using the saved options.
Thank You
Are you able to show the transforms, for context, rather than just the content of that Replace please? I do not yet know how your data is supposed to arrive there.
I assume you need to adjust the way of working.
You need to build a transformation flow in a .tranformation file like:
And when you have a different input file you can not take the transformation to the new input, it loose the information to the columns in which the transformation should execute something. You need just to change in the “Read” transformation the file name, don’t add a new input file, it will not have a link to the next transformations. Change of the input file in the first transformation will only work in the following transformations if you have identical column names (or columns order).
If you have different orders of columns, you have more possibilities by using schema, but you should start with this. For Schema you should check documentation later on (https://www.easydatatransform.com/help/latest/mac/html/index.html?schemas.html). If you want to run multiple fiel through sam process it van be done in batch mode (https://www.easydatatransform.com/help/latest/mac/html/index.html?batch_processing.html).
If you have a .transform file and you want to re-use it with a new input file, you should:
-select the input item
-in the Right pane click on the browse button to choose the new input file
This way you won’t reset all the column related options (which you will if you delete the input).
If you have already deleted the input item, you can reconnect a new input:
But you will have to reset any column related options.
If the columns vary between the input files you might want to use a schema:
