DSXchange

Lookup is distinct combination of key1 and key2. Now key1 and key2 both gets match from same reference dataset and same column. key1 data has no duplicates but key2 has duplicates. now when look is performed every time getting different record count as output. reference data has no duplicates. how t...

Source is db2. If I extract data to sequential file and then open that with Notepad++ it give me "ABCnullnullnull"

with
Convert("ABC "," ","") getting blank output as " "

StripWhiteSpace("ABC ") getting "ABC "

LEN("ABC ") getting 4

not sure what is this coming from db2. so special character it seems

with
Convert("ABC "," ","") getting blank output as " "

StripWhiteSpace("ABC ") getting "ABC "

LEN("ABC ") getting 4

not sure what is this coming from db2. so special character it seems

What's the output you are getting if you use trim(). Are you sure that's NULL or WHITESPACE? If it's WHITESPACE please try with Convert() or Stripwhitespaces(). Convert(" ","",inputcolumn) Those are not whitespace there are null values. also if apply trim function then still nul...

Hi I am getting input data in dataset which in turn go created from db2 with values appened with null. looks like "ABC " Right now using trim funcation not able to remove those. length of my data is varying otherwise i can use substring. let me know how to remove null appended to data.

Srry in case of confusion. In example mentioned earlier Name Addresslineno Address ABC 1 xyz ABC 2 bhc ABC 3 320 DFG 1 frfd DFG 2 fgfg Output required is Name Address1 address2 address3 ABC xyz bhc 320 DFG frfd fgfg So in input i have addrs and addresslineno so in vertical pivot how so map these inp...

thanks now I am trying to vertical pivot.

My question is when I have addr1 addr2 and addr3 in my target. and source is having addrtxt and addrno. how to configure stage vertical pivot to populate field addr1 in target when addrno is 1 in source?

Thanks, what should be the derication in output column tab?
addrcolumn where address no = 1?

Getting input as Name Addresslineno Address ABC 1 xyz ABC 2 bhc ABC 3 320 DFG 1 frfd DFG 2 fgfg Output required is Name Address1 address2 address3 ABC xyz bhc 320 DFG frfd fgfg please drop a note to inplemet this logic, if in sql also will do

have source with number datatype with data 18 decimal place after decimal point.

in server we have limit of 15 precision in decimal datatype

same is the case with parallel?

Yes need that field , what can be the reason for not reading one particular field and any workaround?

one more observation if this transformer stage is moved to someother part in same job then still give same error on same column and all previous stages gives warning as Lookup: When checking operator: On input data set 0: When binding input schema variable "inputData": A transfer adapter i...

getting error in transformer as

Transformer: Error when checking operator: Could not find input field "INPUT_COLUMN".

while field is present in input.

Getting error in Filter Stage: Filter: Error occurred during initializeFromArgs(). Filter: Parse error: Expected 'is' statement ('is true', 'is false') or boolean operator (and, or) got: "-02". Parse error: Expected 'is' statement ('is true', 'is false') or boolean operator (and, or) got: ...