ok, I get that but, if you load an inline statement like the above example, you will get the field quarter automaticlly, you don´t need to creat a new quarter becouse you have it already. or try to post your script to check it out.
Dear Friends, Iwould thanks for the support to figure out the way in creating quater.
I love to share the way of creating quater via mapping concept.
Mapping Load * Inline
LOAD [Transaction ID],
ApplyMap('Month_des',Month) as Month_desc,
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);