Dear All,   I have a question about DataFlux (Data Management Studio 2.4).   I am doing a search within two lists. I have to find which names are in both lists, with different "Sensitivity XX%" on the name to find out possible matching.    I noticed that if I use the match code tool, it reads the fields from the left to the right and creates the match code. E.g.:   1- BANQUE POPULAIRE BOURGOGNE FRANCHE COMTE 2- BANQUE POPULAIRE ALSACE LORRAINE CHAMPAGNE 3- BANQUE POPULAIRE LORRAINE CHAMPAGNE At 65% the lines 1 and 2 are equal, but the 3 not.   If I change the order of the words 1- BANQUE POPULAIRE BOURGOGNE FRANCHE COMTE 2- BANQUE POPULAIRE LORRAINE CHAMPAGNE ALSACE  3- BANQUE POPULAIRE LORRAINE CHAMPAGNE At 65% the lines 2 and 3 are equal, but the 1 not.   Is it possible to create a match code (or a workaround) that does not take in account the order of the words lowering the sensitivy of the match? I mean, I do not expect that BANQUE POPULAIRE equals POPULAIRE BANQUE with a sensitivy=100%, but maybe with a lower sensitivity...yes.   Thank you for your help and for your time.   Best regards, Margherita ... View more

Hello, in the "Rule details" panel I can select "Log to text file". I have two questions to ask: 1- I can specify the location and I can add "Ensure file name is unique", but it add a suffix after the .txt and I cannot open the files (just after renaming the file). How can I use it? 2- in the header, is it possible to put a macro field? I mean, if my task is to check if a field is null and the field could be "city", "number", "zip code",... is it possible to put in the header sometingh like "address with missing values in %%xxx%%" and automaticallz substitute %%xxx%% with "city", "number" or "zip code"? My idea is to monitor two fields applying the same rule/task. Maybe the workaround is to create a Data Validation step + a text output step, but then...how can I monitor it?   Thank you for your time, Margherita ... View more

Hello,   I have access to SAS table in Data Connections (SAS technical support suggest an ODBC connection and the IT team performs it), how can I access to that data using a SAS Code object (in Process Job>>Data Integration)? Have I to set up special setting in the Settings/Inputs tab?   Thank you for your time!     ... View more

Hello!   I am new and I have a trivial issue with the text file output.   I put the .csv extension (double quotation mark as the text qualifier and comma as field delimiter), but I could not have an excel output file with one field in each column. It is like a .txt file e.g. ID,"name" 0,"AAA" 1,"BBB" 2,"CCC"   Thank you for your help!   ... View more