Mapping for last item

[Divyajyothi7]

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)

A	X	Y	Y
B	M		M
C	N		N

Y	1	2
M	5
N	4

A	X	Y	1	2
B	M	5
C	N	4

[Divyajyothi7]

@Yoshiro_Fujimori, @binuacs 

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 

[Yoshiro_Fujimori · Accepted solution]

@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;

od z_ritm	seq_no	aitm	qna
SD00678	1	DG00234	1
SD00678	2	DG00765	4

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.

[Divyajyothi7]

Thank you for your response 

Issue has been resolved