DSXchange

Hi guys, Good afternoon. I'm having a problem with my stage variable. I am using it as a group #. but the problem is, it is inconsistent. My data is this: 01|XXX 02|XXX 01|XXX 02|XXX 03|XXXX 01|XXX 02|XXX 03|XXXX I want to group it this way: 1 01|XXX 1 02|XXX 2 01|XXX 3 02|XXX 3 03|XXXX 4 01|XXX 4 0...

Thank you,chulett for answering my questions with dedication. I really appreciate it.

And, yes. I really have to study more about stage variables. That's reason why I am asking a lot.

Thanks again. I will check the link.

keith

I just wonder, if vReference <-- 0 vCheck <-- If InLink.Col1 = 1 Then InLink.Col1 Else vReference When will vReference change in value? For example, if Col1 <> 1, vCheck =vReference; vCheck=0. So, vCheck is always equal to zero whenever the condition is not met? By the way, thank you for the answeri...

Ah, sorry for that. I will next time.

OK, blank rows.

In my sequential file, it is only blank.

I think it has a line feed so it is not null.

When i extract in on datastage, Datastage neglects the "blank" rows and proceeds to the next row.

Hi guys,

good evening.

I have a problem on extracting a flat file on datastage.

The blank rows are ignored when extracting the data from a flat file.

is there a way that Datastage will consider those blank rows as NULL?

Any help please?

Thanks,
keith

Hi guys, Good evening. I have a problem with my source. In my source, the data looks like below: Col1 Type02|Group1 Type03|Group1 Type04|Group1 Type01|Group2 Type02|Group2 Type03|Group2 Note: Type01 in the Group1 is missing, so made a condition in the variable that if Col1="" then "Mi...

Ah! Now I get it! svProect's value is set into a new value everytime the it encounters a "Type1"! Thank you so much ray.wurlod!
I can now distinguish every project separately.

With all my heart, thanks again!

Keith

This is only a single column singe it is from a flat file. I want to populate the row with the "project" that is located on every type1-line only. So, i want to check on what project does every Other Types (type2, type3, etc...) belongs to.

How can i use it on datastage?

Hi guys,

Is it possible to Set the value of a variable using a variable?

Example:

vReference=0 ; intial value

vCheck=
If Col1=1 then vReference=Col1
Else vReference

Thank you,
keith

Hi guys,

is there a way that i can compare the current row to the previous row?

The logic is this:

If CurrentRec = PrevRec
Then
ColumnOut= PrevRec
Else
Current Row

Thanks,
Keith

Hi guys, i have a data that looks like this: col1,col2 1,A 2,xxx 3,xx 1,B 2,xxx 1,C 2,xx so, i want to repeat the value of each first line of the group. i want it to look like this: col1,col2,col3 1,A,A 2,xxx,A 3,xx,A 1,B,B 2,xxx,B 1,C,C 2,xx,C I can't find a way to to distribute it on every succeed...

Hi guys!

Can you help me on how to check if a file exists in a FTP Server?

I don't have a any idea.

Please help.

Thank you,
Keith

but i need the project# (that is in each type 1) to be iterated for each row. example: input Type 1|xx|project01 Type 2|xxxxx Type 3|xxxxxx Type 1|xx|project02 Type 2|xxxxx Type 3|xxxxxx it must be: project01|Type 1|xx|project01 project01|Type 2|xxxxx project01|Type 3|xxxxxx project02|Type 1|xx|proj...

Will i use a Loop here? I have searched the net on my problem and looping seems to be a possible solution. Can you help me on this?

Hoping for your generous help.

-keith