hi, i know this has been discussed many times before and i am using a previous example from this site that i searched on but i am getting quite odd results.
my source file is:
a|aa,bb,cc
b|
c|dd
the results i am getting is
a|aa
a|aa
b|
c|dd
c|dd
and i require
a|aa
a|bb
a|cc
b|
c|dd
probably something i am missing out, this is my job design:
sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up
sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up
sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up