Concatenate Identification Accreditation For Free

hi this is safe here today we would be introducing one Muslim are you interviews they give you a setup give you a data like this and they ask you or data to be thrown as an output like this so it is nothing but concatenating values on ID column so it will see for 10 we have a pen we have B and 10 we have C so what we have done is we have taken only one record of 10 and the occurrence of second column has been concatenated by a delimiter called comma okay so we will try to achieve this so I've already imported my source and target structures and if you see this is the source and if you go over here so this is there is no data in my target table so as if you will see first of all the data is not in a sorted format so what I'll do is and use a transformation called sorter and I will sort the columns on ID bring in all the ports double click over you and it should be an ascending format so this is done let's move ahead so this is my this is my sorta now what I do is I'd use a transformation called expression and I would be building some conditions over here so bring in the sorted boots now I need to compare this ID column every time so once the ID gets changed I need to start again from the value this is something like that so what I do is and use a variable forth and here I'll use an ID column it's cleared one more port and let's say its name is V underscore flag and made a typo pen string with the other size of 25 now URL writer is conditioned so if my variable ID is equal to ID so at that time what I need to do is I need to concatenate it with a comma separation with the name else I need to start it again copy and paste now let's take this put ahead and copy this variable port so I'm done now I need only one set of occurrence so I will be using a transformation called aggregator and I would be doing a group by on ID so bring this ID and the concatenated beta subsequently connect to the target paper and group by on ID column let's see this mapping mapping is valid mapping me let's go to overflow and connect to the Casa tree and let's create a new workbook and let's create a task that is a session and this is the mapping concatenation so tasks link this to us mapping tab souls is from staging schema target is from star schema change well to normal insert the data no update on delete and truncated before loading let's see this let's execute this workflow so this is getting executed it shows successfully succeeded and let's see the output so if you'll see from my source there were eight records which were being read and in my target table only four records are being written let's see the data in the target so if you'll see 10 has been concatenated with the corresponding column values same way for 20 and 30 and 40 didn't had anything so that's why it's not happy so that's what we were expecting it's a concatenation of column values and that's what we have achieved any queries or any questions please pop up an email on spritzee technologies and...