DSXchange

bhasds

Hi bobbysridhar,

The below command in execute command activity can give you the output.
Then you can pass the command output to the start loop activity(space as delimiter) and to the job

Command-

Code: Select all

cat  filename|xargs| tr -d '\n'

Please correct me if I am wrong.

bhasds

Hi Rphani, If you are using the sequential file stage , then you can use the Filter option in properties tab.You can try the below command in the Filter option to discard trailing records and null records- nawk -F"|" '{if ($1 !~ "Tr") print $0}' count | grep . I have assumed that...

bhasds

Join stage by default will insert tsort operator in both the dataset prior to join if we do not sort the datasets explicitly.This can be seen in the Job score.Please refer to the below post for more information.
viewtopic.php?p=191759

bhasds

Hi wittymy, Its great that you have used routine. However, if you want to do it using sequence activity itself, you can still do it as below- 1. ExecuteCommand1 - Command- echo `date +%Y%m%d%H:%M:%S` 2. ExecuteCommand2 - Command- cat <FileName> | head -1 Trigger in Execute command acivity- We can ch...

bhasds

Hi wittyme,

Yes, you can do that.My logic also not going to abort the job at any cost.If there is no file then it will not hit the job and finish the sequencer successfully.

bhasds

Hi wittyme,

If your DateTimestamp format is YYYYMMDDHH:MM:SS then you can use the below command in execute command-

Code: Select all

cat <FileName> | cut -c  1-8

This will give you only the date and the rest of the thing of my previous post should work as it is.

bhasds

As you said if there is no data then file contains DateTimestamp 20120821 03:44:54. For this, we can do the following in the Job sequence- Execute command - Command- cat <FileName> | nawk -F" " '{print $1}' Trigger in Execute command acivity- a)Link1-This can be mapped to the job to be tri...

bhasds

Thanks a lot ArndW.

bhasds

Hi ArndW/Chullet, I am sorry for misleading hargun.In the above scenario the code given by me will give erroneous result. :( Can you please tell whether the below modification in your code is fine to get the difference between the two dates in form of month? Neg(DaysSinceFromDate(TimeStampToDate(upd...

bhasds

Hi Hargun,

Both the code should give you the same result.So, its your wish which one to use.

bhasds

Or

If you are using the ArndW's code then divide the output of ArndW's code by 30,assuming the number of days per month is 30 .

Code: Select all

Neg(DaysSinceFromDate(TimeStampToDate(update.IssueDate),TimeStampToDate(update.ExpiryDate)))/30

bhasds

Hi Hargun,

The below code should work if you have timestamp in source.

Code: Select all

Neg(MonthFromDate(TimestampToDate(update.IssueDate))- MonthFromDate(TimestampToDate(update.ExpiryDate)))

bhasds

Hi hargun,

You can try the below code which will calculate the difference between the issue_dt and expiry_dt, and give you the result as an integer.

Code: Select all

Neg(MonthFromDate(issue_dt)- MonthFromDate(expiry_dt))

bhasds

In transform stage @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 <2001(in multiple node Configuration file) should work fine.

bhasds

Hi Sachin518,

Sequence Number can be generated in form of row number in Sequential file Stage as well.

sequential file stage--->output--->properties-->options-->RowNumberColumn.

DSXchange

Search found 78 matches

Datatype conversions

Datatype conversions

Reading Data Through Dataset

generating sequence number