Populate Records
Hi All,
Need some suggestion for below implementation ,
Can someone help me with ideas or suggestions?
thanks in advance
Forum Discussion
Hi @psathyanarayan Attaching screen shot for more clear requirement
input 1
input 2
expected results for 1st record in input 2
similarly we should get for other records in input 2
each records from input 1 should get multiple with each records in input 2
Hello @Ajay_Chawda,
Your initial use case is different from the current use case that you sent me later. In the latest use case that you sent out there is no need to switch columns to rows. Hence there is no need to use UNION etc.
I have attached the pipeline and the two CSV files input1.txt and input2.txt that will address your latest requirement use case. You would need to modify the File Reader Snaps configuration to the place where you save your input files as they are all currently pointing to my local system.
Hope this helps.
Community_Case2_2019_05_25.slp (13.9 KB)
input1.txt (110 Bytes)
input2.txt (219 Bytes)
thank you @psathyanarayan for help.
