cancel
Showing results for 
Search instead for 
Did you mean: 

comparing two dso fields

Former Member
0 Kudos

hi gurus

i have data coming from two different sources i have to compare both side fields in one dso and show it into the report

i have validation dso i musing select comman in endroutine to pick up the data from the other dso but somehow the data is not coming into the field is there any other way to do that

thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

It needs to be compared at staging level/loading only.

Check the code. Check if the data types of objects are matching or not.

I hope it will help.

Thanks,

S

Answers (6)

Answers (6)

Former Member
0 Kudos

kkk

Former Member
0 Kudos

helpfull

Former Member
0 Kudos

i m using fuction conversion_exit_alpha_output to eliminate leading zeroes now this i m using in transformation routine

now i have requirement to use this programme in more than one field how do i do that .

thanks.i have done that with one filed that works fine but in the same structre i have more than one fields and in transformation routine its only taking o

Former Member
0 Kudos

Hi again,

Unless both the fields are included for the end routine within transformation, you can include the conversion there. Alternately, within transformation, you map the source fields to the destination DSO. You can include the alpha conversion in there. In the assignment (double click the line or "=") and select formula and select alpha conversion.

Hope it helps

Former Member
0 Kudos

hi

i m trying to use transfer routine in multiple fileds but i cannot. its only apply for one fileld.what is the alternate way

like im trying to use the conversion_exit_alpha_output but it only works for one infoobject i have more than one infoobjects that has leading zeores coming in data.

thanks

Former Member
0 Kudos

hi,

If you need to remove 0s for multiple fileds then you need to write the same conversion for all field in transformation ant field level.

I guess this is the best and effiicient way to perform this.

I hope it will help.

Thanks,'

S

Former Member
0 Kudos

Hi gurus

i m using fuction conversion_exit_alpha_output to eliminate leading zeroes now this i m using in transformation routine

now i have requirement to use this programme in more than one field how do i do that .

thanks

Former Member
0 Kudos

You can include the code and logic in your End routine to do the comparison and field assignment. If you are storing the data from the 2 sources in DSOs, The fields (to be compared) would be

Step 1:Create an Internal table for SOURCE_PACKAGE, and 2 DSO

create variable for the final field

Step2: populate the data in the internal table of DSO1(type /bic/azDSO for custom DSO and /bi0/a0DSO ) & DSO2 based on selection criteria = Source_package-field

include logic to compare and assign the final field = <DSO-field.

Loop at IT_Source_package

move corresponding values from type table to IT_source_package

Endloop.

Append IT_Source_Package to Source_Package

hope this helps.

Samir

Former Member
0 Kudos

or is there are option we can compare two dso data in bex analyzer?