i want to find unique email address for each row…Please guide
eg: If Primary and secondary value is same then only 1 value should be considered
Use the remove duplicate activity .
Can u tell the concept of unique email address
U mean unique cell in each row
the expected output can be interpretated in many forms and was unfortunately not described in the requirements. Lets assume following result output:
Find some starter help on this implemented with a reduced sample data set, but ready by just configure some control variables:
Get_Distincts_manyCols_ConcatedResult.xaml (10.0 KB)
Only considering 4 Columns(i.e Primary.Secondary.Tertiary,Quarternary) out of 6, if any of 4 columns contains same value, eg:Primary = ABC, Secondary = ABC, then ABC should be fetched only once.
let me knw if any doubts in question and guide ,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.