Hi Anbu,
if the List in the order it is no problem, while using the stage variables.
You take one variable for the number, one for to concatinate and one for to
check the numberswitch it the number switches it is true and if not it is
false.
You write to the target table only when the switch is true.
You should add a dummyline to you source table as last line otherwise you
don't get the last info to target table.
Please let us know, if it worked.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 7:17 AM
To: datastage-users@oliver.com
Subject: Concatenation problem.
Hi DS Gurus,
We are using DS 7 on WinNT. I am facing a problem in implementing specific
requirement.
In my source file I have two columns, Countrycode and Countryname. In target
I need to concatanate the Countryname
values based on the Countrycode.
Following is the structure of my source file
Coutrycode,Countryname
100, India
100, US
100, Germany
101,England
101,Australia
In the target I need to populate data as follows.
Countrycode, Countryname
100,India US Germany
101,England Australia
I already tried Pivotal stage and Row Merger stages. But I didnt get
expected results.
How can I achieve this? Kindly revert with your suggestions.
Cheers,
Anbu
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
Mailadmin@wipro.com immediately
and destroy all copies of this message and any attachments.
Concatenation problem.
Concatenation problem.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Concatenation problem.
Hi Wolfgang,
Can you pls brief it?
Cheers,
Anbu
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Tuesday, January 13, 2004 1:34 PM
To: datastage-users@oliver.com
Subject: RE: Concatenation problem.
Hi Anbu,
if the List in the order it is no problem, while using the stage variables. You take one variable for the number, one for to concatinate and one for to check the numberswitch it the number switches it is true and if not it is false.
You write to the target table only when the switch is true.
You should add a dummyline to you source table as last line otherwise you don't get the last info to target table.
Please let us know, if it worked.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 7:17 AM
To: datastage-users@oliver.com
Subject: Concatenation problem.
Hi DS Gurus,
We are using DS 7 on WinNT. I am facing a problem in implementing specific requirement.
In my source file I have two columns, Countrycode and Countryname. In target I need to concatanate the Countryname
values based on the Countrycode.
Following is the structure of my source file
Coutrycode,Countryname
100, India
100, US
100, Germany
101,England
101,Australia
In the target I need to populate data as follows.
Countrycode, Countryname
100,India US Germany
101,England Australia
I already tried Pivotal stage and Row Merger stages. But I didnt get expected results.
How can I achieve this? Kindly revert with your suggestions.
Cheers,
Anbu
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately and destroy all copies of this message and any attachments.
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately
and destroy all copies of this message and any attachments.
Can you pls brief it?
Cheers,
Anbu
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Tuesday, January 13, 2004 1:34 PM
To: datastage-users@oliver.com
Subject: RE: Concatenation problem.
Hi Anbu,
if the List in the order it is no problem, while using the stage variables. You take one variable for the number, one for to concatinate and one for to check the numberswitch it the number switches it is true and if not it is false.
You write to the target table only when the switch is true.
You should add a dummyline to you source table as last line otherwise you don't get the last info to target table.
Please let us know, if it worked.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 7:17 AM
To: datastage-users@oliver.com
Subject: Concatenation problem.
Hi DS Gurus,
We are using DS 7 on WinNT. I am facing a problem in implementing specific requirement.
In my source file I have two columns, Countrycode and Countryname. In target I need to concatanate the Countryname
values based on the Countrycode.
Following is the structure of my source file
Coutrycode,Countryname
100, India
100, US
100, Germany
101,England
101,Australia
In the target I need to populate data as follows.
Countrycode, Countryname
100,India US Germany
101,England Australia
I already tried Pivotal stage and Row Merger stages. But I didnt get expected results.
How can I achieve this? Kindly revert with your suggestions.
Cheers,
Anbu
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately and destroy all copies of this message and any attachments.
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately
and destroy all copies of this message and any attachments.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Concatenation problem.
Yes, I can.
If you look in you manual you can 2.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 9:34 AM
To: datastage-users@oliver.com
Subject: RE: Concatenation problem.
Hi Wolfgang,
Can you pls brief it?
Cheers,
Anbu
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Tuesday, January 13, 2004 1:34 PM
To: datastage-users@oliver.com
Subject: RE: Concatenation problem.
Hi Anbu,
if the List in the order it is no problem, while using the stage variables.
You take one variable for the number, one for to concatinate and one for to
check the numberswitch it the number switches it is true and if not it is
false.
You write to the target table only when the switch is true.
You should add a dummyline to you source table as last line otherwise you
don't get the last info to target table.
Please let us know, if it worked.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 7:17 AM
To: datastage-users@oliver.com
Subject: Concatenation problem.
Hi DS Gurus,
We are using DS 7 on WinNT. I am facing a problem in implementing specific
requirement.
In my source file I have two columns, Countrycode and Countryname. In target
I need to concatanate the Countryname
values based on the Countrycode.
Following is the structure of my source file
Coutrycode,Countryname
100, India
100, US
100, Germany
101,England
101,Australia
In the target I need to populate data as follows.
Countrycode, Countryname
100,India US Germany
101,England Australia
I already tried Pivotal stage and Row Merger stages. But I didnt get
expected results.
How can I achieve this? Kindly revert with your suggestions.
Cheers,
Anbu
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain confidential or privileged information. If you are not the intended
recipient, please notify the sender at Wipro or Mailadmin@wipro.com
immediately and destroy all copies of this message and any attachments.
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
Mailadmin@wipro.com immediately
and destroy all copies of this message and any attachments.
If you look in you manual you can 2.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 9:34 AM
To: datastage-users@oliver.com
Subject: RE: Concatenation problem.
Hi Wolfgang,
Can you pls brief it?
Cheers,
Anbu
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Tuesday, January 13, 2004 1:34 PM
To: datastage-users@oliver.com
Subject: RE: Concatenation problem.
Hi Anbu,
if the List in the order it is no problem, while using the stage variables.
You take one variable for the number, one for to concatinate and one for to
check the numberswitch it the number switches it is true and if not it is
false.
You write to the target table only when the switch is true.
You should add a dummyline to you source table as last line otherwise you
don't get the last info to target table.
Please let us know, if it worked.
Wolfgang
-----Original Message-----
From: raman.anbuchelian@wipro.com [mailto:raman.anbuchelian@wipro.com]
Sent: Tuesday, January 13, 2004 7:17 AM
To: datastage-users@oliver.com
Subject: Concatenation problem.
Hi DS Gurus,
We are using DS 7 on WinNT. I am facing a problem in implementing specific
requirement.
In my source file I have two columns, Countrycode and Countryname. In target
I need to concatanate the Countryname
values based on the Countrycode.
Following is the structure of my source file
Coutrycode,Countryname
100, India
100, US
100, Germany
101,England
101,Australia
In the target I need to populate data as follows.
Countrycode, Countryname
100,India US Germany
101,England Australia
I already tried Pivotal stage and Row Merger stages. But I didnt get
expected results.
How can I achieve this? Kindly revert with your suggestions.
Cheers,
Anbu
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain confidential or privileged information. If you are not the intended
recipient, please notify the sender at Wipro or Mailadmin@wipro.com
immediately and destroy all copies of this message and any attachments.
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
Mailadmin@wipro.com immediately
and destroy all copies of this message and any attachments.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.