Search found 13 matches
- Wed Jan 31, 2018 7:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add missing Week Qty with default value
- Replies: 2
- Views: 2190
- Thu Jan 25, 2018 11:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add missing Week Qty with default value
- Replies: 2
- Views: 2190
Add missing Week Qty with default value
Hello Folks, Need insights on approach for this I have the below file which will have a Column1(which is like a Key);Date(Every Monday of the week);qty I will need to have "N" number of weeks qty for each Column1 Key Value Example Data: Column1;Date;Qty 1;01222018;2 1;01292018;3 1;02052018...
- Wed Apr 19, 2017 7:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup with a Like Operator
- Replies: 4
- Views: 4787
Thanks for the answer Mike. Actually, it is a 4 character column. And it can be 1 character or 2 character ..or 4 character. So, I need to do look up based on what I have in the Table. So, I am thinking starting a lookup with 4 character and then the rejected one goes to another lookup with 3 charac...
- Tue Apr 18, 2017 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup with a Like Operator
- Replies: 4
- Views: 4787
Lookup with a Like Operator
I have a Input file with a Key Column which should be looked up into a table which sometimes might have a starting letter or a full string. So, basically I have to use LIKE for lookup which we don't have in Datastage. Any thoughts on how to accomplish this. One way is to load my input data into anot...
- Sat Dec 17, 2016 6:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Webservices client stage - Fatal error
- Replies: 2
- Views: 2615
- Thu Nov 10, 2016 9:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading Boolean values into Salesforce using Connector
- Replies: 2
- Views: 2352
- Wed Nov 09, 2016 4:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading Boolean values into Salesforce using Connector
- Replies: 2
- Views: 2352
Loading Boolean values into Salesforce using Connector
Sales force Object has Boolean data type fields which need to be loaded using Datastage.While trying to import the field definitions of object using Sales force connector, it defaults to Varchar data type fields. I have manually changes the data type to Bit and tried to load the object, but all the ...
- Tue Oct 25, 2016 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XPATH issues while creating a XML file from a text file
- Replies: 7
- Views: 3829
- Mon Oct 24, 2016 12:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XPATH issues while creating a XML file from a text file
- Replies: 7
- Views: 3829
- Mon Oct 24, 2016 11:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XPATH issues while creating a XML file from a text file
- Replies: 7
- Views: 3829
- Mon Oct 24, 2016 9:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XPATH issues while creating a XML file from a text file
- Replies: 7
- Views: 3829
- Mon Oct 24, 2016 7:14 am
- Forum: General
- Topic: Environment Variables Usage
- Replies: 7
- Views: 2878
- Mon Oct 24, 2016 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XPATH issues while creating a XML file from a text file
- Replies: 7
- Views: 3829
XPATH issues while creating a XML file from a text file
I have to generate a XML file as below by reading the values from a text file Text File:(Some delimited file) 123|John XML file to generate: <Member> <Person Type="ID">123</Person> <Person Type="Name">John</Person> </Member> XPATH I am using in XML Output stage for respective col...