Posts

Showing posts with the label data processing

S) How to merge two different column into a single column

Image
input        Output 1 A                1A 2 B               2B 3 C              3C 4 D              4D           Reformat   Out ::reformat (in)=   begin   Out.alfa :: string_concat ( in.id ,in.alfa );   end     Input DML     record   decimal ( "| " )id ;   string ( "\n " ) alfa ;   end     Output DML   re cord   String(“\n ”) alfa ;   end    

S) How to read different dml file to a single file ?

Image
  use red ef ine format or use read_multi ple file    

S) How to take a count of vowel present in a string ?

Image
 Solution: Redefine Format   record   string( 1) data;   end     FBE   data member [ vector "A","a","E","e","I"," i "," O","o","U","u " ]     Sort   Key –Data     Rollup     Key –Data     out : : rollup(in) =   begin     out. data : : in.data ;     out.cc : : count( in.data );   end;