| table format | Join condition |
| If first 5 characters of the starting of the line is 'C4305' - Write to a dataframe(df) by spliting the data into the columns A, B, C, D…. | Column B is unique |
| If first 5 characters of the starting of the line is 'C4306' - Write to a dataframe(df2) into the columns A1, B1, C1, D1…. | No match here so create new column which takes df[column B] values from before line(acts as a foreign key) |
| If first 5 characters of the starting of the line is 'C4307' - Write to a dataframe(df3) into the columns A2, B2, C2, D2…. | No match here so create new column which takes df[column B] values from before line(acts as a foreign key) |
| They can be considered as parent child relationship |
| Each time the first 3 characters is 'C42' it is a new record |