Feeding variable number of flows with a primary ID into tMap
I have an excel file that has a primary key and a message field. The message field isn't consistent in the number of records it contains and looks something like this:
Loan number: Message
1234 Loan date x
customer name x
1235 Loan Date y
customer name y
second customer name y
loan type y
1236 Loan date Z
Customer name Z
second customer name Z
I know how to replicate the primary id (Loan Number) to all the fields in the message column, but I don't know how to define a variable schema like this. Any help would be greatly appreciated.
First the Dynamic will not be working with open studio as it is paid version functionality.
Second you can try with tDenormalize to concatenate the message in single line and then read it using tBufferInput/tBufferoutput and using comma separation you can differentiate each value, afterwards for schema change I need to check if it is possible or not. If you know the max number of columns then you can directly create them and then using above procedure you can works for the details where loan number don't have much message those columns will be filled with NULL.
