Multiple fixed length formats

Question

Hi everyone,

I am trying to work on a different file that contains two different fixed-length formats. Where the top rows contain information about n following rows. I'm not really sure how to tackle this. I can see that the top rows always start with a number whereas the n following rows always start with letters. Is it possible to add the top rows to n following rows until Alteryx encounters a new top row and so on?

echuong1 · Answer

Are you able to create a dummy dataset? It is a bit difficult to understand your requirements without some sort of visual to follow.

gogotaenzer · Answer

Hi,

I would love to but it is confidential.

mceleavey · Answer

Hi @gogotaenzer ,

Can you please post some data so we can help?

Thanks,

M.