How to solve this problem in Magic ETL - Link items to Header rows
Hi All, Currently we have a dataset which have records in this format: First row is the header record and next three rows are items of the this. but there is no link. I have ranked the dataset and the used a Lag function to join the header and item. Then I have performed the self-join to get Header information to First…