Sunday, 24 October 2021

Abinitio Scenario

1)   Column to row 

Input  - 



Output - 




Meta Pivot - 


Meta Pivot out - 


Rollup - 



Rollup out - 


Reformat - 



2)
 









-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

how to create dml dynamically in Ab-initio

 $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...

  • Important air commands - Part 1
     1) air tag diff -  ->air tag diff -show-all tag1 tag2 (-show-all -optional list objects for which there are no differences) 2) air tag c...
  • m_dump
    1) How to print records from a file where cust_id started with 1234 by using the m_dump command ? m_dump dml data -select 'starts_with(c...
  • how to create dml dynamically in Ab-initio
     $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...