DSXchange

Right now I am using DataStage to accomplish this and was wondering if it could be done through QualityStage's SURVIVE stage.

INPUT :
PROD_KEY| PROD_TYPE
0001| A
0001| C
0001| B
0002| X
0002| A
0003| C


REQUIRED SURVIVED OUTPUT:
PROD_KEY PROD_TYPE
0001| ACB
0002| XA
0003| C

Broadly this problem can be classified into

1. Layout mismatches
2. Data Format issues

What has worked for me is basic awk scripts for "Layout Mismatches" simple count of number of columns.

For "Data Format" issues the isValid() function can be used.

Hope that helps

I am assuming you are using the USADDR ruleset. In your example "1234 A-D Main Street" USADDR breaks it to HouseNumber = 1234 HouseNumberSuffix = A StreetName = D MAIN StreetSuffixType=ST InputPattern =^I-I+T ...... ...... In your case you need to change the pattern file to handle your pat...

I do not know the max number of KEYWORDS that the file could have

In a PX job which stage do I use to split one record into multiple records with the same keys Example Input: AccountId, WordList A001, APPLE|ORANGE|BANANA A002, KIWI|GRAPES A003, PEACH|MANGO|APPLE OUTPUT: AccountId, Words A001, APPLE A001, ORANGE A001, BANANA A002, KIWI A002, GRAPES A003, PEACH A003...

What was the solution to this ???

I had a similar problem and we used QualityStage to resolve it.

How do I get the length of a variable into another variable in a pattern action file

Is something like this possible ?

COPY var1 LEN var2

Thanks

Thanks J well the only reason to avoid DS is that I am trying to build a lightweight solution using only QS as this is supposed to run on individual laptops for users with minimum training. I am just trying to avoid training my business folks on 2 tools Hi ejazsalim, Off the top of my head, I don't ...

Is there an equivalent of the datastage function DCount in QualityStage. What I am trying to do is standardize a file and then look for the number of occurrence of a particular classification. eg : F+W+IWF+CFF My answer should be 4, Since I am looking for all "F" in the pattern. I am tryin...

I wonder... Try 22.0/7.0 as the expression. It may just be that the optimizer is being too clever, recognizing integer arguments and therefore performing integer arithmetic. ... As always Ray you are the best. That worked for me and the output now is 0000000000000000000000000000000000000003.1428571...

I think it was in 1897 that the Indiana state legislature legislated that the value of PI should be 3, to make life easier for geometry teachers. Maybe this has finally reached Virginia? :lol: I find it curious that you are only getting four digits after the decimal place even though you specified ...

You are not giving any argument for RType. By default its trunc_zero and hence truncating everything after the decimal point. In DS Help type DecimalToDecimal, it will give you the help. Read over it and provide the correct RType. I tried that too DecimalToDecimal(22/7, "round_inf") with ...

I have a very simple job which reads from a flat file and writes to target flat file with a transformer in between. In one expression on the transformer I am trying to calculate the value of 22/7 the output column was hand coded with decimal 50,10 nullable=no and description is blank the output that...

Hello QualityStage Guru's
can I have multiple words classified for standardization.

eg : "PAID ON DEATH" standardized to "POD"
Right now I am doing it through the PATTERN file and was wondering if I could do it with the CLS file.

DSguru2B wrote:Use @INROWNUM = 1 constraint in the ouput link by passing the file through a transformer.

That would only return A what about B ?