I need to transform thousands of source records into multiple records as shown in the bottom end, that have the following form:
column A Column B
the result of such source records should get transformed into the following 4 records down below. Means: A record should get created for every comma delimited number in column B. The string in column B contains different amount of comma delimited numbers. sometimes 4 numbers sometimes 25 numbers. Result of the record transformations should look for the example above like this:
column A column B
i dont want to use while loop.