Forum Discussion

venkat475's avatar
venkat475
New Contributor II
2 years ago

reading fixed width cobol file in snaplogic using python script

hi Team, i am currently using this copybook layout in datastage and reading the content in the file.now i am trying to read this content using snaplogic script snap using python script.but i am not ...
koryknick's avatar
koryknick
Employee
2 years ago

adam_gataev - couple questions to clarify the requirements as it will affect how this needs to be solved.

  1. How many levels are possible?  If it always maxes out at 3, the solution is a bit simpler - if it is completely arbitrary and could extend into the dozens, then it is a more complicated solution
  2. Will Branch, Year, and Type always be the key components of your record sets?

Happy Friday!  Hopefully we can get you a solution quickly!

adam_gataev's avatar
adam_gataev
New Contributor II
2 years ago

Hi koryknick,
Thank you for your commenting!

  1. Unfortunately, MaxLevel is not pre-set nor is there a hard limit. It is simply the maximum value of the Level column from the CSV/SQL table.
  2. Yes, all fields in the JSON and the SQL table will always be present. The JSON structure, including fields at the root level or deeper levels, will remain consistent. The only variation is the depth of the levels or whether a row contains a deeper level.

I hope this answered your questions. English is not my native language, it could be that I misunderstood the 2nd question.

Happy Friday to you too!

  • ptaylor's avatar
    ptaylor
    Employee
    10 months ago

    Attached is a pipeline to do this mapping. It looks like this:

    First Mapper:

    Second Mapper:

    Hope that helps!

     

     

  • DirkZ70's avatar
    DirkZ70
    New Contributor
    10 months ago

    Perfect,
    you are a genius 👍
    Your example do exactly what i needed.

    Many thanks,
    Dirk