hi
I have 2 datasets,
dataset-1 and dataset-2 , I'm looking to build hierarchy for dataset -1 , an file with expected output has been attached.
I'm looking to build this sample model with example:(excel file has been attached with real data)
@Divyajyothi7 ,
Sorry if this does not suit your taste, but here is my recommendation.
As I mentioned in a separate thread, you'd better to consider refactoring the data structure of your table for future maintainability.
Just looking at your table, I guess the current structure as follows;
your primary key is [od z_ritm],
the sequence of [z_aitm*] and [z_qna*] are repetitive
>> this should be "flatten" to make the table to 1NF.
the two columns [od z_aitm] and [od z_qna]
the two columns [Right_od z_aitm] and [Right_od z_qna]
>> I am not sure if they are somewhat different from the previous repetitive sequences.
Not knowing the semantics of each field, I would normalize the table as below;
With this structure, you do not need to deal with many fields.
(If you do not care about the order, you may even remove [seq_no].)
And if you want to revert to the original long row format, you can easily do so with Transpose tool and Cross Tab tool like this.
@Yoshiro_Fujimori, @binu_acs
I have attached sample of my workflow , I have joined the two datasets on the basics of lastone , old z_ritm after joining removed columns
Last one , right od z_ritm
Thank you for your response
Issue has been resolved
